APPS.HXC_TIME_CATEGORY_HOOK dependencies on PAY_ACCRUAL_PLANS

Line 26: FROM pay_accrual_plans pap

22: tc.time_Category_name like p_tc_name;
23:
24: CURSOR csr_get_accrual_plan_name ( p_pap_id NUMBER) IS
25: SELECT pap.accrual_plan_name
26: FROM pay_accrual_plans pap
27: WHERE pap.accrual_plan_id = p_pap_id;
28:
29:
30: CURSOR csr_get_accrual_plan_id IS

Line 43: pay_accrual_plans ap

39: , ncr.element_type_id
40: , ncr.element_type_name
41: , ncr.add_or_subtract
42: FROM
43: pay_accrual_plans ap
44: , pay_net_calculation_rules_v ncr
45: WHERE
46: ncr.accrual_plan_id = p_pap_id AND
47: ncr.net_calculation_rule_id = p_ncr_id

Line 96: l_pap_id pay_accrual_plans.accrual_plan_id%TYPE;

92: l_mpc_id hxc_mapping_components.mapping_component_id%TYPE;
93:
94: l_tc_info csr_get_time_category_info%ROWTYPE;
95:
96: l_pap_id pay_accrual_plans.accrual_plan_id%TYPE;
97: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
98: l_min_inc_ncr_id pay_net_calculation_rules.net_calculation_rule_id%TYPE;
99:
100: l_session_id number;

Line 97: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%TYPE;

93:
94: l_tc_info csr_get_time_category_info%ROWTYPE;
95:
96: l_pap_id pay_accrual_plans.accrual_plan_id%TYPE;
97: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
98: l_min_inc_ncr_id pay_net_calculation_rules.net_calculation_rule_id%TYPE;
99:
100: l_session_id number;
101: l_old_user_id number;