APPS.PAY_US_MARK_W2C_PAPER dependencies on PAY_PAYROLL_ACTIONS

Line 79: from pay_payroll_actions ppa

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

Line 155: pay_payroll_actions ppa

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

Line 169: pay_payroll_actions ppa1

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

Line 181: pay_payroll_actions ppa1

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

Line 284: pay_payroll_actions ppa

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

Line 301: pay_payroll_actions ppa1

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

Line 314: pay_payroll_actions ppa1

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

Line 359: pay_payroll_actions ppa

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

Line 375: pay_payroll_actions ppa1

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

Line 387: pay_payroll_actions ppa1

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

Line 442: from pay_payroll_actions ppa,

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