APPS.PAY_US_MARK_W2C_PAPER dependencies on PAY_PAYROLL_ACTIONS

Line 77: from pay_payroll_actions ppa

73: ,ppa.report_qualifier
74: ,ppa.business_group_id
75: ,pay_us_payroll_utils.get_parameter('S_N',
76: ppa.legislative_parameters)
77: from pay_payroll_actions ppa
78: where payroll_action_id = cp_payroll_action_id;
79:
80: ld_start_date date;
81: ld_end_date date;

Line 153: pay_payroll_actions ppa

149: IS
150: select paa.assignment_Action_id
151: from pay_assignment_actions paa,
152: per_all_assignments_f paf,
153: pay_payroll_actions ppa
154: where ppa.business_group_id = cp_business_group_id
155: and ppa.effective_date between cp_start_date and cp_end_date
156: and ppa.action_type = 'X'
157: and ppa.report_type = 'W-2C PAPER'

Line 167: pay_payroll_actions ppa1

163: and paf.assignment_type = 'E'
164: and not exists
165: (select 'x' from pay_Action_interlocks pai,
166: pay_assignment_actions paa1,
167: pay_payroll_actions ppa1
168: where pai.locked_action_id = paa.assignment_action_id
169: and paa1.assignment_action_id = pai.locking_action_id
170: and ppa1.payroll_action_id = paa1.payroll_action_id
171: and ppa1.effective_date between cp_start_date and cp_end_date

Line 179: pay_payroll_actions ppa1

175: and ppa1.action_status = 'C')
176: and not exists
177: (select 'x' from pay_Action_interlocks pai,
178: pay_assignment_actions paa1,
179: pay_payroll_actions ppa1
180: where pai.locked_action_id = paa.assignment_action_id
181: and paa1.assignment_action_id = pai.locking_action_id
182: and ppa1.payroll_action_id = paa1.payroll_action_id
183: and ppa1.effective_date between cp_start_date and cp_end_date

Line 282: pay_payroll_actions ppa

278: lv_sql_string :=
279: 'select distinct paf.person_id
280: from pay_assignment_actions paa,
281: per_all_assignments_f paf,
282: pay_payroll_actions ppa
283: where ppa.business_group_id = '|| ln_business_group_id || '
284: and ppa.effective_date between to_date(''' ||
285: to_char(ld_start_date, 'dd-mon-yyyy') || ''',''dd-mon-yyyy'')
286: and to_date(''' || to_char(ld_end_date, 'dd-mon-yyyy') || ''',''dd-mon-yyyy'')

Line 299: pay_payroll_actions ppa1

295: and :payroll_action_id is not null
296: and not exists
297: (select ''x'' from pay_Action_interlocks pai,
298: pay_assignment_actions paa1,
299: pay_payroll_actions ppa1
300: where pai.locked_action_id = paa.assignment_action_id
301: and paa1.assignment_action_id = pai.locking_action_id
302: and ppa1.payroll_action_id = paa1.payroll_action_id
303: and ppa1.effective_date between to_date(''' ||

Line 312: pay_payroll_actions ppa1

308: and ppa1.action_status = ''C'')
309: and not exists
310: (select ''x'' from pay_Action_interlocks pai,
311: pay_assignment_actions paa1,
312: pay_payroll_actions ppa1
313: where pai.locked_action_id = paa.assignment_action_id
314: and paa1.assignment_action_id = pai.locking_action_id
315: and ppa1.payroll_action_id = paa1.payroll_action_id
316: and ppa1.effective_date between to_date(''' ||

Line 357: pay_payroll_actions ppa

353: paf.person_id,
354: paa.assignment_Action_id
355: from pay_assignment_actions paa,
356: per_all_assignments_f paf,
357: pay_payroll_actions ppa
358: where ppa.business_group_id = cp_business_group_id
359: and ppa.effective_date between cp_start_date and cp_end_date
360: and ppa.action_type = 'X'
361: and ppa.report_type = 'W-2C PAPER'

Line 373: pay_payroll_actions ppa1

369: and cp_end_person_id
370: and not exists
371: (select 'x' from pay_Action_interlocks pai,
372: pay_assignment_actions paa1,
373: pay_payroll_actions ppa1
374: where pai.locked_action_id = paa.assignment_action_id
375: and paa1.assignment_action_id = pai.locking_action_id
376: and ppa1.payroll_action_id = paa1.payroll_action_id
377: and ppa1.effective_date between cp_start_date and cp_end_date

Line 385: pay_payroll_actions ppa1

381: and ppa1.action_status = 'C')
382: and not exists
383: (select 'x' from pay_Action_interlocks pai,
384: pay_assignment_actions paa1,
385: pay_payroll_actions ppa1
386: where pai.locked_action_id = paa.assignment_action_id
387: and paa1.assignment_action_id = pai.locking_action_id
388: and ppa1.payroll_action_id = paa1.payroll_action_id
389: and ppa1.effective_date between cp_start_date and cp_end_date

Line 440: from pay_payroll_actions ppa,

436: WHERE organization_id = cp_tax_unit_id;
437:
438: cursor get_paper_details (cp_assignment_action_id in number) is
439: select creation_date
440: from pay_payroll_actions ppa,
441: pay_assignment_actions paa
442: where paa.assignment_action_id = cp_assignment_action_id
443: and ppa.payroll_action_id = paa.payroll_action_id;
444: