DBA Data[Home] [Help]

APPS.PAY_ELEMENT_TEMPLATE_GEN dependencies on PAY_ELEMENT_TYPE_USAGES_F

Line 793: from pay_element_type_usages_f

789: where iterative_rule_id = p_core_object_id;
790: --
791: cursor csr_seu_core_object_exists(p_core_object_id in number) is
792: select count(0)
793: from pay_element_type_usages_f
794: where element_type_usage_id = p_core_object_id;
795: --
796: cursor csr_sgb_core_object_exists(p_core_object_id in number) is
797: select count(0)

Line 3578: from pay_element_type_usages_f

3574: cursor csr_ele_type_usages_lock(p_element_type_usage_id in number) is
3575: select element_type_usage_id
3576: , object_version_number
3577: , effective_start_date
3578: from pay_element_type_usages_f
3579: where element_type_usage_id = p_element_type_usage_id
3580: for update of element_type_usage_id;
3581: --
3582: cursor csr_gu_bal_exclusions_lock(p_grossup_balances_id in number) is