APPS.PAY_AU_PAYMENT_SUMMARY_REPORT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 80: v_next_action_id pay_assignment_actions.assignment_action_id%type;

76: p_start_person_id in per_all_people_f.person_id%type,
77: p_end_person_id in per_all_people_f.person_id%type,
78: p_chunk in number) is
79:
80: v_next_action_id pay_assignment_actions.assignment_action_id%type;
81:
82: /*Bug2920725 Corrected base tables to support security model*/
83:
84:

Line 96: pay_assignment_actions ppac

92: from per_assignments_f a,
93: per_people_f p,
94: pay_payroll_actions pa,
95: pay_payroll_actions ppa,
96: pay_assignment_actions ppac
97: where pa.payroll_action_id = c_payroll_action_id
98: and p.person_id between c_start_person_id and c_end_person_id
99: and p.person_id = a.person_id
100: and p.business_group_id = pa.business_group_id

Line 114: from pay_assignment_actions ppac1,

110: FROM pay_action_interlocks pail
111: WHERE pail.locked_action_id=ppac.assignment_action_id)
112: and ppac.assignment_action_id in
113: (select max(ppac1.assignment_action_id)
114: from pay_assignment_actions ppac1,
115: pay_payroll_Actions ppaa
116: where ppaa.action_type ='X'
117: and ppaa.action_status ='C'
118: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppaa.legislative_parameters) =

Line 125: select pay_assignment_actions_s.nextval

121: and ppaa.payroll_Action_id = ppac1.payroll_action_id
122: group by ppac1.assignment_id);
123:
124: cursor next_action_id is
125: select pay_assignment_actions_s.nextval
126: from dual;
127:
128:
129: /* Bug 6470581 - Added the Following cursors to get Payment Summary Information

Line 149: ,c_reg_emp IN pay_assignment_actions.tax_unit_id%TYPE

145: (c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
146: ,c_start_person_id IN per_all_people_f.person_id%TYPE
147: ,c_end_person_id IN per_all_people_f.person_id%TYPE
148: ,c_archive_id IN pay_payroll_actions.payroll_action_id%TYPE
149: ,c_reg_emp IN pay_assignment_actions.tax_unit_id%TYPE
150: ,c_financial_year VARCHAR2)
151: IS
152: SELECT DISTINCT a.assignment_id
153: ,pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id

Line 160: ,pay_assignment_actions ppac

156: FROM per_assignments_f a
157: ,per_people_f p
158: ,pay_payroll_actions pa
159: ,pay_payroll_actions ppa
160: ,pay_assignment_actions ppac
161: ,pay_assignment_actions pmaa
162: ,pay_payroll_actions pmpa
163: WHERE pa.payroll_action_id = c_payroll_action_id
164: AND p.person_id between c_start_person_id and c_end_person_id

Line 161: ,pay_assignment_actions pmaa

157: ,per_people_f p
158: ,pay_payroll_actions pa
159: ,pay_payroll_actions ppa
160: ,pay_assignment_actions ppac
161: ,pay_assignment_actions pmaa
162: ,pay_payroll_actions pmpa
163: WHERE pa.payroll_action_id = c_payroll_action_id
164: AND p.person_id between c_start_person_id and c_end_person_id
165: AND p.person_id = a.person_id

Line 188: FROM pay_assignment_actions ppac1,

184: FROM pay_action_interlocks pail
185: WHERE pail.locked_action_id=ppac.assignment_action_id)
186: AND ppac.assignment_action_id IN
187: (SELECT MAX(ppac1.assignment_action_id)
188: FROM pay_assignment_actions ppac1,
189: pay_payroll_Actions ppaa
190: WHERE ppaa.action_type ='X'
191: AND ppaa.action_status ='C'
192: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppaa.legislative_parameters) =

Line 352: pay_assignment_actions pac

348: cursor csr_is_assignemnt_exist (p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE) is
349: select count(ppav.assignment_id)
350: from pay_au_eoy_values_v ppav,
351: pay_payroll_actions ppa,
352: pay_assignment_actions pac
353: where ppa.payroll_action_id= p_payroll_action_id
354: and ppav.payroll_action_id =pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)
355: and ppa.report_type='AU_PAYMENT_SUMMARY_REPORT'
356: and ppav.assignment_id=pac.assignment_id