APPS.PAY_US_W2C_REPORTING_UTILS dependencies on PER_ALL_ASSIGNMENTS_F

Line 254: per_all_assignments_f paf,

250: cpd_end_date date)
251: IS
252: select paa.assignment_action_id
253: from pay_assignment_actions paa,
254: per_all_assignments_f paf,
255: pay_payroll_actions ppa
256: where ppa.business_group_id = cpn_business_group_id
257: and ppa.effective_date between cpd_start_date and cpd_end_date
258: and ppa.action_type = 'X'

Line 437: per_all_assignments_f paf,

433: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 40);
434: lv_sql_string :=
435: 'select distinct paf.person_id
436: from pay_assignment_actions paa,
437: per_all_assignments_f paf,
438: pay_payroll_actions ppa
439: where ppa.business_group_id = '|| ln_business_group_id || '
440: and ppa.effective_date between to_date(''' ||
441: to_char(ld_start_date, 'dd-mon-yyyy') || ''',''dd-mon-yyyy'')

Line 514: per_all_assignments_f paf,

510: IS
511: select distinct paa.assignment_id,
512: paf.person_id
513: from pay_assignment_actions paa,
514: per_all_assignments_f paf,
515: pay_payroll_actions ppa
516: where ppa.business_group_id = cp_business_group_id
517: and ppa.effective_date between cp_start_date and cp_end_date
518: and ppa.action_type = 'X'

Line 592: per_all_assignments_f paf,

588: paa.assignment_Action_id, -- Maximum Assignment Action_ID
589: to_number(substr(paa.serial_number,1,15)) w2c_pp_asg_actid,
590: to_number(substr(paa.serial_number,16,30)) w2c_pp_locked_actid
591: from pay_assignment_actions paa,
592: per_all_assignments_f paf,
593: pay_payroll_actions ppa
594: where ppa.business_group_id = cp_business_group_id
595: and ppa.effective_date between cp_start_date and cp_end_date
596: and ppa.action_type = 'X'

Line 663: per_all_assignments_f paf,

659: --bug 7504239
660: select distinct paa.assignment_action_id
661: --bug 7504239
662: from pay_assignment_actions paa,
663: per_all_assignments_f paf,
664: pay_payroll_actions ppa
665: where ppa.business_group_id = cpn_business_group_id
666: and ppa.effective_date between cpd_start_date and cpd_end_date
667: and ppa.action_type = 'X'

Line 735: per_all_assignments_f paf,

731: paa.assignment_Action_id,
732: ppa.payroll_action_id,
733: to_number(substr(paa.serial_number,1,15)) w2c_pp_asg_actid
734: from pay_assignment_actions paa,
735: per_all_assignments_f paf,
736: pay_payroll_actions ppa
737: where ppa.business_group_id = cp_business_group_id
738: and ppa.effective_date between cp_start_date and cp_end_date
739: and ppa.action_type = 'X'