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_GB_RTI_P60 dependencies on PER_ALL_PEOPLE_F

Line 323: FROM per_all_people_f per

319: decode(per_information10,'Y','Y',NULL) agg_paye_flag,
320: decode(per_information9,'Y','Y',NULL) multiple_asg_flag,
321: per.employee_number employee_number,
322: per.EXPENSE_CHECK_SEND_TO_ADDRESS
323: FROM per_all_people_f per
324: WHERE per.person_id = p_person_id
325: AND g_end_year BETWEEN per.effective_start_date
326: AND per.effective_end_date;
327:

Line 366: l_last_name per_all_people_f.last_name%TYPE;

362: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_p60_emp_det';
363: l_arch BOOLEAN;
364: l_asg_id number;
365:
366: l_last_name per_all_people_f.last_name%TYPE;
367: l_first_name per_all_people_f.first_name%TYPE;
368: l_middle_name per_all_people_f.middle_names%TYPE;
369: l_date_of_birth DATE;
370: l_title per_all_people_f.title%TYPE;

Line 367: l_first_name per_all_people_f.first_name%TYPE;

363: l_arch BOOLEAN;
364: l_asg_id number;
365:
366: l_last_name per_all_people_f.last_name%TYPE;
367: l_first_name per_all_people_f.first_name%TYPE;
368: l_middle_name per_all_people_f.middle_names%TYPE;
369: l_date_of_birth DATE;
370: l_title per_all_people_f.title%TYPE;
371: l_expense_check_to_address per_all_people_f.expense_check_send_to_address%TYPE;

Line 368: l_middle_name per_all_people_f.middle_names%TYPE;

364: l_asg_id number;
365:
366: l_last_name per_all_people_f.last_name%TYPE;
367: l_first_name per_all_people_f.first_name%TYPE;
368: l_middle_name per_all_people_f.middle_names%TYPE;
369: l_date_of_birth DATE;
370: l_title per_all_people_f.title%TYPE;
371: l_expense_check_to_address per_all_people_f.expense_check_send_to_address%TYPE;
372: l_ni_number per_all_people_f.national_identifier%TYPE;

Line 370: l_title per_all_people_f.title%TYPE;

366: l_last_name per_all_people_f.last_name%TYPE;
367: l_first_name per_all_people_f.first_name%TYPE;
368: l_middle_name per_all_people_f.middle_names%TYPE;
369: l_date_of_birth DATE;
370: l_title per_all_people_f.title%TYPE;
371: l_expense_check_to_address per_all_people_f.expense_check_send_to_address%TYPE;
372: l_ni_number per_all_people_f.national_identifier%TYPE;
373: l_sex per_all_people_f.sex%TYPE;
374: l_pensioner_indicator VARCHAR2(1);

Line 371: l_expense_check_to_address per_all_people_f.expense_check_send_to_address%TYPE;

367: l_first_name per_all_people_f.first_name%TYPE;
368: l_middle_name per_all_people_f.middle_names%TYPE;
369: l_date_of_birth DATE;
370: l_title per_all_people_f.title%TYPE;
371: l_expense_check_to_address per_all_people_f.expense_check_send_to_address%TYPE;
372: l_ni_number per_all_people_f.national_identifier%TYPE;
373: l_sex per_all_people_f.sex%TYPE;
374: l_pensioner_indicator VARCHAR2(1);
375: l_aggregated_paye_flag VARCHAR2(1);

Line 372: l_ni_number per_all_people_f.national_identifier%TYPE;

368: l_middle_name per_all_people_f.middle_names%TYPE;
369: l_date_of_birth DATE;
370: l_title per_all_people_f.title%TYPE;
371: l_expense_check_to_address per_all_people_f.expense_check_send_to_address%TYPE;
372: l_ni_number per_all_people_f.national_identifier%TYPE;
373: l_sex per_all_people_f.sex%TYPE;
374: l_pensioner_indicator VARCHAR2(1);
375: l_aggregated_paye_flag VARCHAR2(1);
376: l_multiple_asg_flag VARCHAR2(1);

Line 373: l_sex per_all_people_f.sex%TYPE;

369: l_date_of_birth DATE;
370: l_title per_all_people_f.title%TYPE;
371: l_expense_check_to_address per_all_people_f.expense_check_send_to_address%TYPE;
372: l_ni_number per_all_people_f.national_identifier%TYPE;
373: l_sex per_all_people_f.sex%TYPE;
374: l_pensioner_indicator VARCHAR2(1);
375: l_aggregated_paye_flag VARCHAR2(1);
376: l_multiple_asg_flag VARCHAR2(1);
377: l_employee_number per_all_people_f.employee_number%TYPE;

Line 377: l_employee_number per_all_people_f.employee_number%TYPE;

373: l_sex per_all_people_f.sex%TYPE;
374: l_pensioner_indicator VARCHAR2(1);
375: l_aggregated_paye_flag VARCHAR2(1);
376: l_multiple_asg_flag VARCHAR2(1);
377: l_employee_number per_all_people_f.employee_number%TYPE;
378: l_address_line1 per_addresses.address_line1%type;
379: l_address_line2 per_addresses.address_line2%type;
380: l_address_line3 per_addresses.address_line3%type;
381: l_town_or_city VARCHAR2(30);

Line 697: FROM per_all_people_f pap,

693: SELECT trim(NVL(asg.primary_flag,'N')) asg_primary_flag,
694: trim(NVL(pap.per_information9,'N')) per_ni_agg_flag,
695: trim(NVL(pap.per_information10,'N')) per_paye_agg_flag,
696: asg.assignment_number assignment_number
697: FROM per_all_people_f pap,
698: per_all_assignments_f asg,
699: pay_assignment_actions paa,
700: pay_payroll_actions ppa
701: WHERE paa.assignment_action_id = p_last_asg_action_id

Line 749: per_all_people_f papf

745: cursor csr_agg_primary_asg is
746: select paa.assignment_id
747: from pay_assignment_actions paa,
748: per_all_assignments_f paaf,
749: per_all_people_f papf
750: where paaf.person_id = p_person_id --41650 --
751: and paaf.assignment_id = paa.assignment_id
752: and paa.payroll_action_id = p_pactid --923889 --
753: and papf.person_id = paaf.person_id

Line 3181: FROM per_all_people_f ppf,

3177: -- sqlstr must contain one and only one entry of :payroll_action_id
3178: -- it must be ordered by person_id
3179: --
3180: sqlstr := 'SELECT DISTINCT person_id
3181: FROM per_all_people_f ppf,
3182: pay_payroll_actions ppa
3183: WHERE ppa.payroll_action_id = :payroll_action_id
3184: AND ppa.business_group_id +0= ppf.business_group_id
3185: --and rownum < 50

Line 3242: FROM per_all_people_f pap,

3238: SELECT asg.person_id person_id,
3239: trim(asg.primary_flag) asg_primary_flag,
3240: trim(nvl(pap.per_information10,'N')) per_agg_flag,
3241: trim(nvl(pap.per_information9,'N')) ni_agg_flag
3242: FROM per_all_people_f pap,
3243: per_all_assignments_f asg
3244: WHERE asg.assignment_id = c_asg_id
3245: AND pap.person_id = asg.person_id
3246: AND asg.business_group_id = l_business_group_id

Line 3270: from per_all_people_f pap,

3266: select distinct paaf.assignment_id assignment_id,
3267: trim(paaf.primary_flag) asg_primary_flag,
3268: trim(pap.per_information10) per_agg_flag,
3269: pap.person_id
3270: from per_all_people_f pap,
3271: per_all_assignments_f paaf,
3272: per_assignment_status_types past,
3273: pay_all_payrolls_f papf,
3274: hr_soft_coding_keyflex flex

Line 3282: per_all_people_f pap2

3278: and paaf.assignment_status_type_id = past.assignment_status_type_id
3279: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN','TERM_ASSIGN')
3280: and pap.effective_start_date =
3281: ( select max(pap2.effective_start_date) from
3282: per_all_people_f pap2
3283: where pap2.person_id = pap.person_id
3284: and pap2.effective_start_date <= c_eff_date
3285: )
3286: and paaf.effective_start_date =

Line 3861: FROM per_all_people_f pap,

3857: SELECT trim(NVL(asg.primary_flag,'N')) asg_primary_flag,
3858: trim(NVL(pap.per_information9,'N')) per_ni_agg_flag,
3859: trim(NVL(pap.per_information10,'N')) per_paye_agg_flag,
3860: asg.payroll_id payroll_id
3861: FROM per_all_people_f pap,
3862: per_all_assignments_f asg,
3863: pay_assignment_actions paa
3864: WHERE paa.assignment_action_id = c_asg_act_id
3865: AND paa.assignment_id = asg.assignment_id

Line 4734: per_all_people_f pap

4730: paa.EFFECTIVE_END_DATE end_date,
4731: pap.person_id
4732: FROM per_all_assignments_f paa,
4733: per_assignment_status_types past,
4734: per_all_people_f pap
4735: WHERE paa.person_id = pap.person_id
4736: AND paa.assignment_id = c_assignment_id
4737: AND past.ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID
4738: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 4741: per_all_people_f pap2

4737: AND past.ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID
4738: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
4739: and pap.effective_start_date =
4740: ( select max(pap2.effective_start_date) from
4741: per_all_people_f pap2
4742: where pap2.person_id = pap.person_id
4743: and pap2.effective_start_date <= l_effective_date
4744: )
4745: and paa.effective_start_date =