DBA Data[Home] [Help]

APPS.PAY_CA_RULES dependencies on HR_SOFT_CODING_KEYFLEX

Line 93: from hr_soft_coding_keyflex hsck

89: cursor cur_tax_unit(cp_asg_act_id in number) is
90: select segment1 T4_RL1_GRE
91: ,segment11 T4A_RL1_GRE
92: ,segment12 T4A_RL2_GRE
93: from hr_soft_coding_keyflex hsck
94: ,per_all_assignments_f paf
95: ,pay_assignment_actions paa
96: ,pay_payroll_actions ppa
97: where paa.assignment_action_id = cp_asg_act_id

Line 115: from hr_soft_coding_keyflex hsck

111: select decode(segment1, NULL, 0, 1 ) +
112: decode(segment11, NULL, 0, 1 ) +
113: decode(segment12, NULL, 0, 1 ) tot_no_of_tu
114: ,nvl(segment1, nvl(segment11,segment12) ) tax_unit_id
115: from hr_soft_coding_keyflex hsck
116: ,per_all_assignments_f paf
117: ,pay_assignment_actions paa
118: ,pay_payroll_actions ppa
119: where paa.assignment_action_id = cp_asg_act_id

Line 364: hr_soft_coding_keyflex target,

360: p_date_earned date,
361: p_assignment_id number) IS
362: SELECT target.SEGMENT4
363: FROM /* route for SCL keyflex - assignment level */
364: hr_soft_coding_keyflex target,
365: per_all_assignments_f ASSIGN
366: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date
367: AND ASSIGN.effective_end_date
368: AND ASSIGN.assignment_id = p_assignment_id