DBA Data[Home] [Help]

APPS.PAY_CA_RULES dependencies on HR_SOFT_CODING_KEYFLEX

Line 125: from hr_soft_coding_keyflex hsck

121: cursor cur_tax_unit(cp_asg_act_id in number) is
122: select segment1 T4_RL1_GRE
123: ,segment11 T4A_RL1_GRE
124: ,segment12 T4A_RL2_GRE
125: from hr_soft_coding_keyflex hsck
126: ,per_all_assignments_f paf
127: ,pay_assignment_actions paa
128: ,pay_payroll_actions ppa
129: where paa.assignment_action_id = cp_asg_act_id

Line 147: from hr_soft_coding_keyflex hsck

143: select decode(segment1, NULL, 0, 1 ) +
144: decode(segment11, NULL, 0, 1 ) +
145: decode(segment12, NULL, 0, 1 ) tot_no_of_tu
146: ,nvl(segment1, nvl(segment11,segment12) ) tax_unit_id
147: from hr_soft_coding_keyflex hsck
148: ,per_all_assignments_f paf
149: ,pay_assignment_actions paa
150: ,pay_payroll_actions ppa
151: where paa.assignment_action_id = cp_asg_act_id

Line 1051: hr_soft_coding_keyflex target,

1047: p_date_earned date,
1048: p_assignment_id number) IS
1049: SELECT target.SEGMENT4
1050: FROM /* route for SCL keyflex - assignment level */
1051: hr_soft_coding_keyflex target,
1052: per_all_assignments_f ASSIGN
1053: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date
1054: AND ASSIGN.effective_end_date
1055: AND ASSIGN.assignment_id = p_assignment_id