APPS.HXC_TIME_CATEGORY_HOOK dependencies on PAY_NET_CALCULATION_RULES

Line 32: FROM pay_net_calculation_rules ncr

28:
29:
30: CURSOR csr_get_accrual_plan_id IS
31: SELECT ncr.accrual_plan_id
32: FROM pay_net_calculation_rules ncr
33: WHERE ncr.net_calculation_rule_id = p_net_calculation_rule_id;
34:
35:
36: CURSOR csr_get_elements ( p_pap_id NUMBER, p_ncr_id NUMBER ) IS

Line 44: , pay_net_calculation_rules_v ncr

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
48: AND

Line 76: FROM pay_net_calculation_rules

72: WHERe tcc.time_category_id = tc.time_category_id );
73:
74: CURSOR csr_get_min_inc_ncr ( p_pap_id NUMBER ) IS
75: SELECT MIN (net_calculation_rule_id)
76: FROM pay_net_calculation_rules
77: WHERE accrual_plan_id = p_pap_id
78: AND add_or_subtract = 1;
79:
80: l_accrual_info csr_get_elements%ROWTYPE;

Line 98: l_min_inc_ncr_id pay_net_calculation_rules.net_calculation_rule_id%TYPE;

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;
102: l_old_resp_id number;