eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_PAYMENT_SUMMARY_REPORT dependencies on PAY_PAYROLL_ACTIONS

Line 45: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

41: -- of assignments eligible for archive report process.
42: -------------------------------------------------------------------------
43:
44: procedure range_code
45: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
46: p_sql out NOCOPY varchar2) is
47: begin
48: hr_utility.set_location('Start of range_code',1);
49:

Line 54: ' pay_payroll_actions pa' ||

50: /*Bug2920725 Corrected base tables to support security model*/
51:
52: p_sql := ' select distinct p.person_id' ||
53: ' from per_people_f p,' ||
54: ' pay_payroll_actions pa' ||
55: ' where pa.payroll_action_id = :payroll_action_id' ||
56: ' and p.business_group_id = pa.business_group_id' ||
57: ' order by p.person_id';
58:

Line 75: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

71: -- the cursor to select assignment action selects assignment id for which
72: -- archival has been done.
73:
74: procedure assignment_action_code
75: (p_payroll_action_id in pay_payroll_actions.payroll_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:

Line 86: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

82: /*Bug2920725 Corrected base tables to support security model*/
83:
84:
85: cursor process_assignments
86: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
87: c_start_person_id in per_all_people_f.person_id%type,
88: c_end_person_id in per_all_people_f.person_id%type) is
89: select distinct a.assignment_id,
90: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,

Line 94: pay_payroll_actions pa,

90: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,
91: ppac.assignment_action_id
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

Line 95: pay_payroll_actions ppa,

91: ppac.assignment_action_id
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

Line 115: pay_payroll_Actions ppaa

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) =
119: pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pa.legislative_parameters) --2610141

Line 134: (c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

130: and asignments eligible for Self Printed process for Amended PS
131: */
132:
133: CURSOR c_get_paysum_details
134: (c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
135: IS
136: SELECT to_number(pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppa.legislative_parameters)) registered_employer
137: ,pay_core_utils.get_parameter('ARCHIVE_ID', ppa.legislative_parameters) archive_id
138: ,NVL(pay_core_utils.get_parameter('PAY_SUM_TYPE', ppa.legislative_parameters),'O') payment_summary_type

Line 140: FROM pay_payroll_actions ppa

136: SELECT to_number(pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppa.legislative_parameters)) registered_employer
137: ,pay_core_utils.get_parameter('ARCHIVE_ID', ppa.legislative_parameters) archive_id
138: ,NVL(pay_core_utils.get_parameter('PAY_SUM_TYPE', ppa.legislative_parameters),'O') payment_summary_type
139: ,pay_core_utils.get_parameter('FINANCIAL_YEAR', ppa.legislative_parameters) fin_year
140: FROM pay_payroll_actions ppa
141: WHERE ppa.payroll_action_id = c_payroll_action_id;
142:
143:
144: CURSOR c_amend_process_assignments

Line 145: (c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE

141: WHERE ppa.payroll_action_id = c_payroll_action_id;
142:
143:
144: CURSOR c_amend_process_assignments
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

Line 148: ,c_archive_id IN pay_payroll_actions.payroll_action_id%TYPE

144: CURSOR c_amend_process_assignments
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

Line 158: ,pay_payroll_actions pa

154: ,ppac.assignment_action_id
155: ,pmaa.assignment_action_id datafile_action_id
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

Line 159: ,pay_payroll_actions ppa

155: ,pmaa.assignment_action_id datafile_action_id
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

Line 162: ,pay_payroll_actions pmpa

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
166: AND p.business_group_id = pa.business_group_id

Line 189: pay_payroll_Actions ppaa

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) =
193: pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pa.legislative_parameters) --2610141

Line 302: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

298: is
299: l_count number :=0;
300: ps_request_id NUMBER;
301: l_formula_id ff_formulas_f.formula_id%TYPE;
302: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
303: l_sort_order1 varchar2(40);
304: l_sort_order2 varchar2(40):=null;
305: l_sort_order3 varchar2(40):=null;
306: l_sort_order4 varchar2(40):=null;

Line 309: l_current_chunk_number pay_payroll_actions.current_chunk_number%TYPE;

305: l_sort_order3 varchar2(40):=null;
306: l_sort_order4 varchar2(40):=null;
307: l_passed_sort_order varchar2(40);
308: l_print_style VARCHAR2(2);
309: l_current_chunk_number pay_payroll_actions.current_chunk_number%TYPE;
310: l_print_together VARCHAR2(80);
311: l_print_return BOOLEAN;
312: l_duplex_print_flag varchar2(2);
313: l_template_name varchar2(80); -- Bug 4859876

Line 320: from pay_payroll_actions p

316:
317:
318: cursor csr_get_current_chunk_number(p_payroll_action_id number) is
319: select p.current_chunk_number
320: from pay_payroll_actions p
321: where payroll_action_id = p_payroll_action_id;
322:
323:
324: cursor csr_get_formula_id(p_formula_name VARCHAR2) IS

Line 340: FROM pay_payroll_actions pact,

336: SELECT printer,
337: print_style,
338: decode(save_output_flag, 'Y', 'TRUE', 'N', 'FALSE') save_output,
339: number_of_copies /* Bug: 3768288 */
340: FROM pay_payroll_actions pact,
341: fnd_concurrent_requests fcr
342: WHERE fcr.request_id = pact.request_id
343: AND pact.payroll_action_id = p_payroll_action_id;
344:

Line 348: cursor csr_is_assignemnt_exist (p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE) is

344:
345: /*Bug# 5743270
346: Cursor checks whether any assignment exist for which Printed Payment Summary(PUI) need to be produced
347: */
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

Line 351: pay_payroll_actions ppa,

347: */
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'