APPS.PAY_CA_RULES dependencies on PER_ALL_ASSIGNMENTS_F

Line 126: ,per_all_assignments_f paf

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
130: and ppa.payroll_action_id = paa.payroll_action_id

Line 148: ,per_all_assignments_f paf

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
152: and ppa.payroll_action_id = paa.payroll_action_id

Line 521: , per_all_assignments_f paf

517: , pea.segment4 er_transit_code /*13849708*/
518: , pea.segment3 er_account_number /*13849708*/
519: FROM pay_assignment_actions paa
520: , pay_action_information pai
521: , per_all_assignments_f paf
522: , per_all_people_f ppf
523: , pay_external_accounts pea
524: , pay_org_payment_methods_f popm
525: WHERE paa.assignment_action_id = cp_chk_assactid

Line 1052: per_all_assignments_f ASSIGN

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
1056: AND target.soft_coding_keyflex_id = ASSIGN.soft_coding_keyflex_id