APPS.PAY_US_FLS_REPORTING_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 264: from pay_assignment_actions paa,

260: replace( replace(replace(hoi.org_information1,'-'),'/'),' ')
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

Line 369: pay_assignment_actions paa,

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
373: between to_date(''' || to_char(ld_start_date, 'dd/mm/yyyy')

Line 391: pay_assignment_actions paa1,

387: and not exists
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

Line 450: pay_assignment_actions paa,

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
454: and cp_end_date

Line 470: pay_assignment_actions paa1,

466: and not exists
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

Line 549: select pay_assignment_actions_s.nextval

545: exit;
546: end if;
547:
548: hr_utility.set_location(gv_package || '.action_creation', 50);
549: select pay_assignment_actions_s.nextval
550: into ln_locking_action_id
551: from dual;
552:
553: -- insert into pay_assignment_actions.

Line 553: -- insert into pay_assignment_actions.

549: select pay_assignment_actions_s.nextval
550: into ln_locking_action_id
551: from dual;
552:
553: -- insert into pay_assignment_actions.
554: hr_nonrun_asact.insact(ln_locking_action_id, ln_assignment_id,
555: p_payroll_action_id, p_chunk, ln_emp_tax_unit_id);
556: hr_utility.set_location(gv_package || '.action_creation', 60);
557:

Line 561: update pay_assignment_actions paa

557:
558: -- insert an interlock to this action
559: hr_nonrun_asact.insint(ln_locking_action_id, ln_assignment_action_id);
560:
561: update pay_assignment_actions paa
562: set paa.serial_number = ln_assignment_action_id
563: where paa.assignment_action_id = ln_locking_action_id;
564:
565: hr_utility.set_location(gv_package || '.action_creation', 60);

Line 1022: pay_assignment_actions paa,

1018: ,nvl(sum(to_number(action_information28)),0) action_information28
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