APPS.PAY_ELEMENT_TEMPLATE_GEN dependencies on PAY_SUB_CLASSIFICATION_RULES_F

Line 758: from pay_sub_classification_rules_f

754: where defined_balance_id = p_core_object_id;
755: --
756: cursor csr_ssr_core_object_exists(p_core_object_id in number) is
757: select count(0)
758: from pay_sub_classification_rules_f
759: where sub_classification_rule_id = p_core_object_id;
760: --
761: cursor csr_sbc_core_object_exists(p_core_object_id in number) is
762: select count(0)

Line 1805: from pay_sub_classification_rules_f

1801: (p_element_type_id in number
1802: ,p_classification_id in number
1803: ) is
1804: select sub_classification_rule_id
1805: from pay_sub_classification_rules_f
1806: where element_type_id = p_element_type_id
1807: and classification_id = p_classification_id;
1808: begin
1809: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 3530: from pay_sub_classification_rules_f

3526: cursor csr_sub_classi_rules_lock(p_sub_classification_rule_id in number) is
3527: select sub_classification_rule_id
3528: , rowid
3529: , effective_start_date
3530: from pay_sub_classification_rules_f
3531: where sub_classification_rule_id = p_sub_classification_rule_id
3532: for update of sub_classification_rule_id;
3533: --
3534: cursor csr_balance_classis_lock(p_balance_classification_id in number) is