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

Line 746: l_person_id per_all_people_f.person_id%TYPE;

742: p_tax_ref IN VARCHAR2,
743: p_proll_eff_date IN DATE)
744: RETURN DATE IS
745: l_min_active per_all_assignments_f.effective_start_date%TYPE;
746: l_person_id per_all_people_f.person_id%TYPE;
747: l_pos_id per_all_assignments_f.period_of_service_id%TYPE;
748: l_new_min_active per_all_assignments_f.effective_start_date%TYPE;
749: l_term_and_xfer VARCHAR2(1);
750: l_old_paye_ref hr_soft_coding_keyflex.segment1%TYPE;

Line 947: l_person_id per_all_people_f.person_id%TYPE;

943: p_proll_eff_date IN DATE)
944: RETURN DATE IS
945: l_min_active per_all_assignments_f.effective_start_date%TYPE;
946: l_max_active per_all_assignments_f.effective_start_date%TYPE;
947: l_person_id per_all_people_f.person_id%TYPE;
948: l_pos_id per_all_assignments_f.period_of_service_id%TYPE;
949: l_new_max_active per_all_assignments_f.effective_start_date%TYPE;
950: l_term_and_xfer VARCHAR2(1);
951: l_old_paye_ref hr_soft_coding_keyflex.segment1%TYPE;

Line 1726: FROM per_all_people_f ppf,

1722: -- sqlstr must contain one and only one entry of :payroll_action_id
1723: -- it must be ordered by person_id
1724: --
1725: sqlstr := 'SELECT DISTINCT person_id
1726: FROM per_all_people_f ppf,
1727: pay_payroll_actions ppa
1728: WHERE ppa.payroll_action_id = :payroll_action_id
1729: AND ppa.business_group_id +0= ppf.business_group_id
1730: ORDER BY ppf.person_id';

Line 1860: per_all_people_f per

1856: FROM per_all_assignments_f asg,
1857: pay_all_payrolls_f ppf,
1858: hr_soft_coding_keyflex flex,
1859: hr_organization_information org,
1860: per_all_people_f per
1861: WHERE asg.person_id BETWEEN stperson AND endperson
1862: AND asg.business_group_id +0 = p_bg_id
1863: AND asg.effective_end_date >= p_min_start_year_date
1864: AND asg.effective_start_date <= p_max_end_year_date

Line 1936: per_all_people_f per

1932: decode(per.per_information9,'Y','Y',NULL) multiple_asg_flag,
1933: rowidtochar(pass.rowid) charrowid,
1934: 'Y' tax_ref_xfer
1935: FROM
1936: per_all_people_f per
1937: ,per_all_assignments_f PASS
1938: ,per_all_assignments_f ASS
1939: ,pay_all_payrolls_f NROLL
1940: ,hr_soft_coding_keyflex FLEX

Line 2346: per_all_people_f pap

2342: FROM pay_assignment_actions act1,
2343: pay_assignment_actions act2,
2344: per_all_assignments_f asg1,
2345: per_all_assignments_f asg2,
2346: per_all_people_f pap
2347: WHERE act1.assignment_action_id = p_asg_act_id
2348: AND act1.assignment_id = asg1.assignment_id
2349: AND asg1.person_id = pap.person_id
2350: AND g_end_year between pap.effective_start_date and pap.effective_end_date

Line 3139: l_person_id per_all_people_f.person_id%TYPE;

3135: l_payroll_tax_dist VARCHAR2(3);
3136: --
3137: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
3138: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3139: l_person_id per_all_people_f.person_id%TYPE;
3140: l_organization_id hr_organization_units.organization_id%TYPE;
3141: l_location_id per_all_assignments_f.location_id%TYPE;
3142: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
3143: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;

Line 3170: l_last_name per_all_people_f.last_name%TYPE;

3166: l_paye_eff_date DATE;
3167: l_paye_details_eff_date DATE;
3168: --
3169: --
3170: l_last_name per_all_people_f.last_name%TYPE;
3171: l_first_name per_all_people_f.first_name%TYPE;
3172: l_middle_name per_all_people_f.middle_names%TYPE;
3173: l_date_of_birth DATE;
3174: l_title per_all_people_f.title%TYPE;

Line 3171: l_first_name per_all_people_f.first_name%TYPE;

3167: l_paye_details_eff_date DATE;
3168: --
3169: --
3170: l_last_name per_all_people_f.last_name%TYPE;
3171: l_first_name per_all_people_f.first_name%TYPE;
3172: l_middle_name per_all_people_f.middle_names%TYPE;
3173: l_date_of_birth DATE;
3174: l_title per_all_people_f.title%TYPE;
3175: l_expense_check_to_address per_all_people_f.expense_check_send_to_address%TYPE;

Line 3172: l_middle_name per_all_people_f.middle_names%TYPE;

3168: --
3169: --
3170: l_last_name per_all_people_f.last_name%TYPE;
3171: l_first_name per_all_people_f.first_name%TYPE;
3172: l_middle_name per_all_people_f.middle_names%TYPE;
3173: l_date_of_birth DATE;
3174: l_title per_all_people_f.title%TYPE;
3175: l_expense_check_to_address per_all_people_f.expense_check_send_to_address%TYPE;
3176: l_ni_number per_all_people_f.national_identifier%TYPE;

Line 3174: l_title per_all_people_f.title%TYPE;

3170: l_last_name per_all_people_f.last_name%TYPE;
3171: l_first_name per_all_people_f.first_name%TYPE;
3172: l_middle_name per_all_people_f.middle_names%TYPE;
3173: l_date_of_birth DATE;
3174: l_title per_all_people_f.title%TYPE;
3175: l_expense_check_to_address per_all_people_f.expense_check_send_to_address%TYPE;
3176: l_ni_number per_all_people_f.national_identifier%TYPE;
3177: l_sex per_all_people_f.sex%TYPE;
3178: l_pensioner_indicator VARCHAR2(1);

Line 3175: l_expense_check_to_address per_all_people_f.expense_check_send_to_address%TYPE;

3171: l_first_name per_all_people_f.first_name%TYPE;
3172: l_middle_name per_all_people_f.middle_names%TYPE;
3173: l_date_of_birth DATE;
3174: l_title per_all_people_f.title%TYPE;
3175: l_expense_check_to_address per_all_people_f.expense_check_send_to_address%TYPE;
3176: l_ni_number per_all_people_f.national_identifier%TYPE;
3177: l_sex per_all_people_f.sex%TYPE;
3178: l_pensioner_indicator VARCHAR2(1);
3179: l_aggregated_paye_flag VARCHAR2(1);

Line 3176: l_ni_number per_all_people_f.national_identifier%TYPE;

3172: l_middle_name per_all_people_f.middle_names%TYPE;
3173: l_date_of_birth DATE;
3174: l_title per_all_people_f.title%TYPE;
3175: l_expense_check_to_address per_all_people_f.expense_check_send_to_address%TYPE;
3176: l_ni_number per_all_people_f.national_identifier%TYPE;
3177: l_sex per_all_people_f.sex%TYPE;
3178: l_pensioner_indicator VARCHAR2(1);
3179: l_aggregated_paye_flag VARCHAR2(1);
3180: l_multiple_asg_flag VARCHAR2(1);

Line 3177: l_sex per_all_people_f.sex%TYPE;

3173: l_date_of_birth DATE;
3174: l_title per_all_people_f.title%TYPE;
3175: l_expense_check_to_address per_all_people_f.expense_check_send_to_address%TYPE;
3176: l_ni_number per_all_people_f.national_identifier%TYPE;
3177: l_sex per_all_people_f.sex%TYPE;
3178: l_pensioner_indicator VARCHAR2(1);
3179: l_aggregated_paye_flag VARCHAR2(1);
3180: l_multiple_asg_flag VARCHAR2(1);
3181: --

Line 3452: FROM per_all_people_f per

3448: substr(sex,1,1) sex ,
3449: decode(substr(per_information4,1,1),'Y','P',' ') pensioner_indicator,
3450: decode(per_information10,'Y','Y',NULL) agg_paye_flag,
3451: decode(per_information9,'Y','Y',NULL) multiple_asg_flag -- MII
3452: FROM per_all_people_f per
3453: WHERE per.person_id = p_person_id
3454: AND g_end_year BETWEEN per.effective_start_date
3455: AND per.effective_end_date;
3456: --

Line 3461: FROM per_all_people_f per

3457: cursor csr_director(p_person_id NUMBER) IS
3458: SELECT 'D'
3459: FROM dual
3460: WHERE EXISTS (SELECT '1'
3461: FROM per_all_people_f per
3462: WHERE p_person_id = per.person_id
3463: AND per.effective_start_date <= g_end_year
3464: AND per.effective_end_date >= g_start_year
3465: AND substr(per_information2,1,1) = 'Y')