APPS.PAY_US_FLS_REPORTING_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 134: from pay_payroll_actions ppa

130: ,ppa.report_qualifier
131: ,ppa.report_type
132: ,ppa.report_category
133: ,ppa.legislative_parameters
134: from pay_payroll_actions ppa
135: where payroll_action_id = cp_payroll_action_id;
136:
137: ld_start_date DATE;
138: ld_end_date DATE;

Line 265: pay_payroll_actions ppa

261: from hr_organization_information hoi
262: where org_information_context = 'Employer Identification'
263: and exists (select 'x'
264: from pay_assignment_actions paa,
265: pay_payroll_actions ppa
266: where ppa.payroll_action_id = paa.payroll_action_id
267: and ppa.business_group_id = cp_business_group_id
268: and ppa.effective_date between cp_start_date
269: and cp_end_date

Line 368: from pay_payroll_actions ppa,

364: hr_utility.set_location(gv_package || '.range_code', 60);
365:
366: lv_sql_string :=
367: 'select distinct paf.person_id
368: from pay_payroll_actions ppa,
369: pay_assignment_actions paa,
370: per_assignments_f paf
371: where ppa.business_group_id = ' || ln_business_group_id || '
372: and ppa.effective_date

Line 392: pay_payroll_actions ppa1

388: (select /*+ ORDERED */
389: ''x''
390: from pay_action_interlocks pai,
391: pay_assignment_actions paa1,
392: pay_payroll_actions ppa1
393: where pai.locked_action_id = paa.assignment_action_id
394: and paa1.assignment_action_id = pai.locking_action_id
395: and ppa1.payroll_action_id = paa1.payroll_action_id
396: and ppa1.action_type =''X''

Line 449: from pay_payroll_actions ppa,

445: select paa.assignment_id,
446: ppa.effective_date,
447: paa.tax_unit_id,
448: paa.assignment_action_id
449: from pay_payroll_actions ppa,
450: pay_assignment_actions paa,
451: per_assignments_f paf
452: where ppa.business_group_id = cp_business_group_id
453: and ppa.effective_date between cp_start_date

Line 471: pay_payroll_actions ppa1

467: (select /*+ ORDERED */
468: 'x'
469: from pay_action_interlocks pai,
470: pay_assignment_actions paa1,
471: pay_payroll_actions ppa1
472: where pai.locked_action_id = paa.assignment_action_id
473: and paa1.assignment_action_id = pai.locking_action_id
474: and ppa1.payroll_action_id = paa1.payroll_action_id
475: and ppa1.action_type = 'X'

Line 1023: pay_payroll_actions ppa -- Bug 3343962

1019: ,nvl(sum(to_number(action_information29)),0) action_information29
1020: ,action_information30
1021: from pay_action_information pai,
1022: pay_assignment_actions paa,
1023: pay_payroll_actions ppa -- Bug 3343962
1024: where pai.tax_unit_id = cp_tax_unit_id
1025: and paa.payroll_action_id = cp_payroll_action_id
1026: and ppa.payroll_action_id = cp_payroll_action_id
1027: and ppa.payroll_action_id = paa.payroll_action_id