APPS.PAY_ELEMENT_TEMPLATE_GEN dependencies on PAY_SUB_CLASSIFICATION_RULES_F

Line 755: from pay_sub_classification_rules_f

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

Line 1787: from pay_sub_classification_rules_f

1783: (p_element_type_id in number
1784: ,p_classification_id in number
1785: ) is
1786: select sub_classification_rule_id
1787: from pay_sub_classification_rules_f
1788: where element_type_id = p_element_type_id
1789: and classification_id = p_classification_id;
1790: begin
1791: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 3512: from pay_sub_classification_rules_f

3508: cursor csr_sub_classi_rules_lock(p_sub_classification_rule_id in number) is
3509: select sub_classification_rule_id
3510: , rowid
3511: , effective_start_date
3512: from pay_sub_classification_rules_f
3513: where sub_classification_rule_id = p_sub_classification_rule_id
3514: for update of sub_classification_rule_id;
3515: --
3516: cursor csr_balance_classis_lock(p_balance_classification_id in number) is