DBA Data[Home] [Help]

APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on HXT_EARNING_RULES

Line 1093: FROM hxt_earning_rules egr, hxt_add_elem_info_f aei

1089:
1090: CURSOR c_get_base_hours_type (p_earning_policy_id NUMBER)
1091: IS
1092: SELECT egr.element_type_id
1093: FROM hxt_earning_rules egr, hxt_add_elem_info_f aei
1094: WHERE egr.egp_id = p_earning_policy_id
1095: AND aei.element_type_id = egr.element_type_id
1096: AND aei.earning_category = 'REG'
1097: AND egr.egr_type <> 'HOL';

Line 1418: FROM hxt_earning_rules egr, hxt_add_elem_info_f aei

1414:
1415: CURSOR c_get_base_hours_type (p_earning_policy_id NUMBER)
1416: IS
1417: SELECT egr.element_type_id
1418: FROM hxt_earning_rules egr, hxt_add_elem_info_f aei
1419: WHERE egr.egp_id = p_earning_policy_id
1420: AND aei.element_type_id = egr.element_type_id
1421: AND aei.earning_category = 'REG'
1422: AND egr.egr_type <> 'HOL';