eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_P45_PKG dependencies on PER_PEOPLE_F

Line 1591: 'from per_people_f ppf, '||

1587: ELSE
1588: -- Normal range not restricting by payroll_id.
1589: hr_utility.set_location(l_proc,30);
1590: sqlstr := 'select distinct person_id '||
1591: 'from per_people_f ppf, '||
1592: 'pay_payroll_actions ppa '||
1593: 'where ppa.payroll_action_id = :payroll_action_id '||
1594: 'and ppa.business_group_id = ppf.business_group_id '||
1595: 'order by ppf.person_id';

Line 2775: l_person_id per_people_f.person_id%TYPE;

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);
2779: l_period_of_service_id NUMBER;

Line 2781: l_last_name per_people_f.last_name%TYPE;

2777: l_deceased_flag VARCHAR2(1);
2778: l_agg_paye_flag VARCHAR2(1);
2779: l_period_of_service_id NUMBER;
2780: l_org_name HR_ALL_ORGANIZATION_units.name%TYPE;
2781: l_last_name per_people_f.last_name%TYPE;
2782: l_first_name per_people_f.first_name%TYPE;
2783: l_middle_name per_people_f.middle_names%TYPE; /*Bug 6710229*/
2784: l_title per_people_f.title%TYPE;
2785: l_date_of_birth per_people_f.date_of_birth%TYPE;

Line 2782: l_first_name per_people_f.first_name%TYPE;

2778: l_agg_paye_flag VARCHAR2(1);
2779: l_period_of_service_id NUMBER;
2780: l_org_name HR_ALL_ORGANIZATION_units.name%TYPE;
2781: l_last_name per_people_f.last_name%TYPE;
2782: l_first_name per_people_f.first_name%TYPE;
2783: l_middle_name per_people_f.middle_names%TYPE; /*Bug 6710229*/
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;

Line 2783: l_middle_name per_people_f.middle_names%TYPE; /Bug 6710229/

2779: l_period_of_service_id NUMBER;
2780: l_org_name HR_ALL_ORGANIZATION_units.name%TYPE;
2781: l_last_name per_people_f.last_name%TYPE;
2782: l_first_name per_people_f.first_name%TYPE;
2783: l_middle_name per_people_f.middle_names%TYPE; /*Bug 6710229*/
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;

Line 2784: l_title per_people_f.title%TYPE;

2780: l_org_name HR_ALL_ORGANIZATION_units.name%TYPE;
2781: l_last_name per_people_f.last_name%TYPE;
2782: l_first_name per_people_f.first_name%TYPE;
2783: l_middle_name per_people_f.middle_names%TYPE; /*Bug 6710229*/
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;

Line 2785: l_date_of_birth per_people_f.date_of_birth%TYPE;

2781: l_last_name per_people_f.last_name%TYPE;
2782: l_first_name per_people_f.first_name%TYPE;
2783: l_middle_name per_people_f.middle_names%TYPE; /*Bug 6710229*/
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: --

Line 2786: l_sex per_people_f.sex%TYPE;

2782: l_first_name per_people_f.first_name%TYPE;
2783: l_middle_name per_people_f.middle_names%TYPE; /*Bug 6710229*/
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;

Line 2787: l_ni_number per_people_f.national_identifier%TYPE;

2783: l_middle_name per_people_f.middle_names%TYPE; /*Bug 6710229*/
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;