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 1708: 'from per_people_f ppf, '||

1704: ELSE
1705: -- Normal range not restricting by payroll_id.
1706: hr_utility.set_location(l_proc,30);
1707: sqlstr := 'select distinct person_id '||
1708: 'from per_people_f ppf, '||
1709: 'pay_payroll_actions ppa '||
1710: 'where ppa.payroll_action_id = :payroll_action_id '||
1711: 'and ppa.business_group_id = ppf.business_group_id '||
1712: 'order by ppf.person_id';

Line 2792: l_first_name per_people_f.first_name%TYPE:= first_name;

2788: l_addline2 per_addresses.address_line2%TYPE:= address_line2;
2789: l_addline3 per_addresses.address_line3%TYPE:=address_line3 ;
2790: l_assignment_number per_assignments_f.assignment_number%TYPE:=assignment_number ;
2791: l_county per_addresses.region_1%type:= county;
2792: l_first_name per_people_f.first_name%TYPE:= first_name;
2793: l_middle_name per_people_f.middle_names%TYPE:= middle_name;
2794: l_last_name per_people_f.last_name%TYPE:= last_name;
2795: l_ni_number per_people_f.national_identifier%TYPE:= national_insurance_number;
2796: l_postal_code per_addresses.postal_code%TYPE:= postal_code;

Line 2793: l_middle_name per_people_f.middle_names%TYPE:= middle_name;

2789: l_addline3 per_addresses.address_line3%TYPE:=address_line3 ;
2790: l_assignment_number per_assignments_f.assignment_number%TYPE:=assignment_number ;
2791: l_county per_addresses.region_1%type:= county;
2792: l_first_name per_people_f.first_name%TYPE:= first_name;
2793: l_middle_name per_people_f.middle_names%TYPE:= middle_name;
2794: l_last_name per_people_f.last_name%TYPE:= last_name;
2795: l_ni_number per_people_f.national_identifier%TYPE:= national_insurance_number;
2796: l_postal_code per_addresses.postal_code%TYPE:= postal_code;
2797: l_title per_people_f.title%TYPE:= title ;

Line 2794: l_last_name per_people_f.last_name%TYPE:= last_name;

2790: l_assignment_number per_assignments_f.assignment_number%TYPE:=assignment_number ;
2791: l_county per_addresses.region_1%type:= county;
2792: l_first_name per_people_f.first_name%TYPE:= first_name;
2793: l_middle_name per_people_f.middle_names%TYPE:= middle_name;
2794: l_last_name per_people_f.last_name%TYPE:= last_name;
2795: l_ni_number per_people_f.national_identifier%TYPE:= national_insurance_number;
2796: l_postal_code per_addresses.postal_code%TYPE:= postal_code;
2797: l_title per_people_f.title%TYPE:= title ;
2798: l_addline4 per_addresses.town_or_city%TYPE := town_or_city; --

Line 2795: l_ni_number per_people_f.national_identifier%TYPE:= national_insurance_number;

2791: l_county per_addresses.region_1%type:= county;
2792: l_first_name per_people_f.first_name%TYPE:= first_name;
2793: l_middle_name per_people_f.middle_names%TYPE:= middle_name;
2794: l_last_name per_people_f.last_name%TYPE:= last_name;
2795: l_ni_number per_people_f.national_identifier%TYPE:= national_insurance_number;
2796: l_postal_code per_addresses.postal_code%TYPE:= postal_code;
2797: l_title per_people_f.title%TYPE:= title ;
2798: l_addline4 per_addresses.town_or_city%TYPE := town_or_city; --
2799: l_effective_date date := effective_date;

Line 2797: l_title per_people_f.title%TYPE:= title ;

2793: l_middle_name per_people_f.middle_names%TYPE:= middle_name;
2794: l_last_name per_people_f.last_name%TYPE:= last_name;
2795: l_ni_number per_people_f.national_identifier%TYPE:= national_insurance_number;
2796: l_postal_code per_addresses.postal_code%TYPE:= postal_code;
2797: l_title per_people_f.title%TYPE:= title ;
2798: l_addline4 per_addresses.town_or_city%TYPE := town_or_city; --
2799: l_effective_date date := effective_date;
2800:
2801: BEGIN

Line 3131: l_person_id per_people_f.person_id%TYPE;

3127: l_tax_ref_transfer VARCHAR2(1);
3128: l_transfer_date DATE:=NULL;
3129: --
3130: l_assignment_number per_assignments_f.assignment_number%TYPE;
3131: l_person_id per_people_f.person_id%TYPE;
3132: l_asg_effective_end_date DATE;
3133: l_deceased_flag VARCHAR2(1);
3134: l_agg_paye_flag VARCHAR2(1);
3135: l_period_of_service_id NUMBER;

Line 3137: l_last_name per_people_f.last_name%TYPE;

3133: l_deceased_flag VARCHAR2(1);
3134: l_agg_paye_flag VARCHAR2(1);
3135: l_period_of_service_id NUMBER;
3136: l_org_name HR_ALL_ORGANIZATION_units.name%TYPE;
3137: l_last_name per_people_f.last_name%TYPE;
3138: l_first_name per_people_f.first_name%TYPE;
3139: l_middle_name per_people_f.middle_names%TYPE; /*Bug 6710229*/
3140: l_title per_people_f.title%TYPE;
3141: l_date_of_birth per_people_f.date_of_birth%TYPE;

Line 3138: l_first_name per_people_f.first_name%TYPE;

3134: l_agg_paye_flag VARCHAR2(1);
3135: l_period_of_service_id NUMBER;
3136: l_org_name HR_ALL_ORGANIZATION_units.name%TYPE;
3137: l_last_name per_people_f.last_name%TYPE;
3138: l_first_name per_people_f.first_name%TYPE;
3139: l_middle_name per_people_f.middle_names%TYPE; /*Bug 6710229*/
3140: l_title per_people_f.title%TYPE;
3141: l_date_of_birth per_people_f.date_of_birth%TYPE;
3142: l_sex per_people_f.sex%TYPE;

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

3135: l_period_of_service_id NUMBER;
3136: l_org_name HR_ALL_ORGANIZATION_units.name%TYPE;
3137: l_last_name per_people_f.last_name%TYPE;
3138: l_first_name per_people_f.first_name%TYPE;
3139: l_middle_name per_people_f.middle_names%TYPE; /*Bug 6710229*/
3140: l_title per_people_f.title%TYPE;
3141: l_date_of_birth per_people_f.date_of_birth%TYPE;
3142: l_sex per_people_f.sex%TYPE;
3143: l_ni_number per_people_f.national_identifier%TYPE;

Line 3140: l_title per_people_f.title%TYPE;

3136: l_org_name HR_ALL_ORGANIZATION_units.name%TYPE;
3137: l_last_name per_people_f.last_name%TYPE;
3138: l_first_name per_people_f.first_name%TYPE;
3139: l_middle_name per_people_f.middle_names%TYPE; /*Bug 6710229*/
3140: l_title per_people_f.title%TYPE;
3141: l_date_of_birth per_people_f.date_of_birth%TYPE;
3142: l_sex per_people_f.sex%TYPE;
3143: l_ni_number per_people_f.national_identifier%TYPE;
3144: l_payroll_id per_assignments_f.payroll_id%TYPE;

Line 3141: l_date_of_birth per_people_f.date_of_birth%TYPE;

3137: l_last_name per_people_f.last_name%TYPE;
3138: l_first_name per_people_f.first_name%TYPE;
3139: l_middle_name per_people_f.middle_names%TYPE; /*Bug 6710229*/
3140: l_title per_people_f.title%TYPE;
3141: l_date_of_birth per_people_f.date_of_birth%TYPE;
3142: l_sex per_people_f.sex%TYPE;
3143: l_ni_number per_people_f.national_identifier%TYPE;
3144: l_payroll_id per_assignments_f.payroll_id%TYPE;
3145: --

Line 3142: l_sex per_people_f.sex%TYPE;

3138: l_first_name per_people_f.first_name%TYPE;
3139: l_middle_name per_people_f.middle_names%TYPE; /*Bug 6710229*/
3140: l_title per_people_f.title%TYPE;
3141: l_date_of_birth per_people_f.date_of_birth%TYPE;
3142: l_sex per_people_f.sex%TYPE;
3143: l_ni_number per_people_f.national_identifier%TYPE;
3144: l_payroll_id per_assignments_f.payroll_id%TYPE;
3145: --
3146: l_address_line1 per_addresses.address_line1%TYPE;

Line 3143: l_ni_number per_people_f.national_identifier%TYPE;

3139: l_middle_name per_people_f.middle_names%TYPE; /*Bug 6710229*/
3140: l_title per_people_f.title%TYPE;
3141: l_date_of_birth per_people_f.date_of_birth%TYPE;
3142: l_sex per_people_f.sex%TYPE;
3143: l_ni_number per_people_f.national_identifier%TYPE;
3144: l_payroll_id per_assignments_f.payroll_id%TYPE;
3145: --
3146: l_address_line1 per_addresses.address_line1%TYPE;
3147: l_address_line2 per_addresses.address_line2%TYPE;