APPS.PAY_P45_PKG dependencies on PER_ASSIGNMENTS_F

Line 1122: per_assignments_f ass,

1118: ass.ASSIGNMENT_ID
1119: from hr_organization_information oi,
1120: pay_payrolls_f roll,
1121: hr_soft_coding_keyflex flex,
1122: per_assignments_f ass,
1123: fnd_sessions sess
1124: where oi.ORG_INFORMATION_CONTEXT = 'Tax Details References'
1125: and roll.business_group_id + 0 = oi.organization_id
1126: /* normally P45 is for leaver so pick up data on the assignment_end_date */

Line 2769: l_assignment_id per_assignments_f.assignment_id%TYPE;

2765: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
2766: l_ovn NUMBER;
2767: l_some_warning BOOLEAN;
2768: --
2769: l_assignment_id per_assignments_f.assignment_id%TYPE;
2770: l_termination_date DATE;
2771: l_tax_ref_transfer VARCHAR2(1);
2772: l_transfer_date DATE:=NULL;
2773: --

Line 2774: l_assignment_number per_assignments_f.assignment_number%TYPE;

2770: l_termination_date DATE;
2771: l_tax_ref_transfer VARCHAR2(1);
2772: l_transfer_date DATE:=NULL;
2773: --
2774: l_assignment_number per_assignments_f.assignment_number%TYPE;
2775: l_person_id per_people_f.person_id%TYPE;
2776: l_asg_effective_end_date DATE;
2777: l_deceased_flag VARCHAR2(1);
2778: l_agg_paye_flag VARCHAR2(1);

Line 2788: l_payroll_id per_assignments_f.payroll_id%TYPE;

2784: l_title per_people_f.title%TYPE;
2785: l_date_of_birth per_people_f.date_of_birth%TYPE;
2786: l_sex per_people_f.sex%TYPE;
2787: l_ni_number per_people_f.national_identifier%TYPE;
2788: l_payroll_id per_assignments_f.payroll_id%TYPE;
2789: --
2790: l_address_line1 per_addresses.address_line1%TYPE;
2791: l_address_line2 per_addresses.address_line2%TYPE;
2792: l_address_line3 per_addresses.address_line3%TYPE;

Line 3534: per_assignments_f paf,

3530: act.assignment_action_id archive_action,
3531: act.assignment_id
3532: FROM pay_payroll_actions pact,
3533: pay_assignment_actions act,
3534: per_assignments_f paf,
3535: pay_action_interlocks pai,
3536: ff_archive_items fai
3537: WHERE pact.report_type ='P45'
3538: AND pact.report_qualifier ='GB'

Line 3572: -- FROM per_assignments_f paf2

3568: /* restrict to one row per asg. */
3569: -- Comment out this code as it will be replace by distinct
3570: --AND paf.effective_start_date =
3571: -- (SELECT max(paf2.effective_start_date)
3572: -- FROM per_assignments_f paf2
3573: -- WHERE paf2.assignment_id = paf.assignment_id)
3574: /* commnet out this code and replace by the code below */
3575: --AND NOT EXISTS (SELECT 1
3576: -- FROM pay_action_interlocks pai

Line 3595: per_assignments_f paf,

3591: act.assignment_action_id archive_action,
3592: act.assignment_id
3593: from pay_payroll_actions pact,
3594: pay_assignment_actions act,
3595: per_assignments_f paf,
3596: pay_action_interlocks pai,
3597: pay_population_ranges ppr,
3598: ff_archive_items fai
3599: WHERE pact.report_type ='P45'

Line 3636: -- FROM per_assignments_f paf2

3632: /* restrict to one row per asg. */
3633: /* Comment out the code for performance fix */
3634: --AND paf.effective_start_date =
3635: -- (SELECT max(paf2.effective_start_date)
3636: -- FROM per_assignments_f paf2
3637: -- WHERE paf2.assignment_id = paf.assignment_id)
3638: --AND NOT EXISTS (SELECT 1
3639: -- FROM pay_action_interlocks pai
3640: -- WHERE pai.locked_action_id = act.assignment_action_id);