APPS.PAY_CA_RULES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 68: pay_assignment_actions paa

64:
65: cursor csr_get_jd is
66: Select employment_province, geocode
67: from pay_ca_emp_all_fedtax_info_v cft,
68: pay_assignment_actions paa
69: where cft.assignment_id = paa.assignment_id
70: and paa.assignment_action_id = p_asg_act_id;
71:
72: BEGIN

Line 95: ,pay_assignment_actions paa

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
98: and ppa.payroll_action_id = paa.payroll_action_id
99: and paf.assignment_id = paa.assignment_id

Line 117: ,pay_assignment_actions paa

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
120: and ppa.payroll_action_id = paa.payroll_action_id
121: and paf.assignment_id = paa.assignment_id

Line 247: FROM per_assignments_f paf, pay_assignment_actions paa

243: PROCEDURE add_custom_xml as
244:
245: /* CURSOR get_assignment_number(p_asg_action_id number) IS
246: SELECT assignment_number
247: FROM per_assignments_f paf, pay_assignment_actions paa
248: WHERE paa.assignment_action_id = p_asg_action_id
249: and paa.assignment_id = paf.assignment_id; */
250:
251: TYPE char_tab IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;