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 722: l_person_id per_all_people_f.person_id%TYPE;

718: p_tax_ref IN VARCHAR2,
719: p_proll_eff_date IN DATE)
720: RETURN DATE IS
721: l_min_active per_all_assignments_f.effective_start_date%TYPE;
722: l_person_id per_all_people_f.person_id%TYPE;
723: l_pos_id per_all_assignments_f.period_of_service_id%TYPE;
724: l_new_min_active per_all_assignments_f.effective_start_date%TYPE;
725: l_term_and_xfer VARCHAR2(1);
726: l_old_paye_ref hr_soft_coding_keyflex.segment1%TYPE;

Line 923: l_person_id per_all_people_f.person_id%TYPE;

919: p_proll_eff_date IN DATE)
920: RETURN DATE IS
921: l_min_active per_all_assignments_f.effective_start_date%TYPE;
922: l_max_active per_all_assignments_f.effective_start_date%TYPE;
923: l_person_id per_all_people_f.person_id%TYPE;
924: l_pos_id per_all_assignments_f.period_of_service_id%TYPE;
925: l_new_max_active per_all_assignments_f.effective_start_date%TYPE;
926: l_term_and_xfer VARCHAR2(1);
927: l_old_paye_ref hr_soft_coding_keyflex.segment1%TYPE;

Line 1679: FROM per_all_people_f ppf,

1675: -- sqlstr must contain one and only one entry of :payroll_action_id
1676: -- it must be ordered by person_id
1677: --
1678: sqlstr := 'SELECT DISTINCT person_id
1679: FROM per_all_people_f ppf,
1680: pay_payroll_actions ppa
1681: WHERE ppa.payroll_action_id = :payroll_action_id
1682: AND ppa.business_group_id +0= ppf.business_group_id
1683: ORDER BY ppf.person_id';

Line 1813: per_all_people_f per

1809: FROM per_all_assignments_f asg,
1810: pay_all_payrolls_f ppf,
1811: hr_soft_coding_keyflex flex,
1812: hr_organization_information org,
1813: per_all_people_f per
1814: WHERE asg.person_id BETWEEN stperson AND endperson
1815: AND asg.business_group_id +0 = p_bg_id
1816: AND asg.effective_end_date >= p_min_start_year_date
1817: AND asg.effective_start_date <= p_max_end_year_date

Line 1888: per_all_people_f per

1884: decode(per.per_information9,'Y','Y',NULL) multiple_asg_flag,
1885: rowidtochar(pass.rowid) charrowid,
1886: 'Y' tax_ref_xfer
1887: FROM
1888: per_all_people_f per
1889: ,per_all_assignments_f PASS
1890: ,per_all_assignments_f ASS
1891: ,pay_all_payrolls_f NROLL
1892: ,hr_soft_coding_keyflex FLEX

Line 2297: per_all_people_f pap

2293: FROM pay_assignment_actions act1,
2294: pay_assignment_actions act2,
2295: per_all_assignments_f asg1,
2296: per_all_assignments_f asg2,
2297: per_all_people_f pap
2298: WHERE act1.assignment_action_id = p_asg_act_id
2299: AND act1.assignment_id = asg1.assignment_id
2300: AND asg1.person_id = pap.person_id
2301: AND g_end_year between pap.effective_start_date and pap.effective_end_date

Line 3024: l_person_id per_all_people_f.person_id%TYPE;

3020: l_payroll_tax_dist VARCHAR2(3);
3021: --
3022: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
3023: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3024: l_person_id per_all_people_f.person_id%TYPE;
3025: l_organization_id hr_organization_units.organization_id%TYPE;
3026: l_location_id per_all_assignments_f.location_id%TYPE;
3027: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
3028: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;

Line 3055: l_last_name per_all_people_f.last_name%TYPE;

3051: l_paye_eff_date DATE;
3052: l_paye_details_eff_date DATE;
3053: --
3054: --
3055: l_last_name per_all_people_f.last_name%TYPE;
3056: l_first_name per_all_people_f.first_name%TYPE;
3057: l_middle_name per_all_people_f.middle_names%TYPE;
3058: l_date_of_birth DATE;
3059: l_title per_all_people_f.title%TYPE;

Line 3056: l_first_name per_all_people_f.first_name%TYPE;

3052: l_paye_details_eff_date DATE;
3053: --
3054: --
3055: l_last_name per_all_people_f.last_name%TYPE;
3056: l_first_name per_all_people_f.first_name%TYPE;
3057: l_middle_name per_all_people_f.middle_names%TYPE;
3058: l_date_of_birth DATE;
3059: l_title per_all_people_f.title%TYPE;
3060: l_expense_check_to_address per_all_people_f.expense_check_send_to_address%TYPE;

Line 3057: l_middle_name per_all_people_f.middle_names%TYPE;

3053: --
3054: --
3055: l_last_name per_all_people_f.last_name%TYPE;
3056: l_first_name per_all_people_f.first_name%TYPE;
3057: l_middle_name per_all_people_f.middle_names%TYPE;
3058: l_date_of_birth DATE;
3059: l_title per_all_people_f.title%TYPE;
3060: l_expense_check_to_address per_all_people_f.expense_check_send_to_address%TYPE;
3061: l_ni_number per_all_people_f.national_identifier%TYPE;

Line 3059: l_title per_all_people_f.title%TYPE;

3055: l_last_name per_all_people_f.last_name%TYPE;
3056: l_first_name per_all_people_f.first_name%TYPE;
3057: l_middle_name per_all_people_f.middle_names%TYPE;
3058: l_date_of_birth DATE;
3059: l_title per_all_people_f.title%TYPE;
3060: l_expense_check_to_address per_all_people_f.expense_check_send_to_address%TYPE;
3061: l_ni_number per_all_people_f.national_identifier%TYPE;
3062: l_sex per_all_people_f.sex%TYPE;
3063: l_pensioner_indicator VARCHAR2(1);

Line 3060: l_expense_check_to_address per_all_people_f.expense_check_send_to_address%TYPE;

3056: l_first_name per_all_people_f.first_name%TYPE;
3057: l_middle_name per_all_people_f.middle_names%TYPE;
3058: l_date_of_birth DATE;
3059: l_title per_all_people_f.title%TYPE;
3060: l_expense_check_to_address per_all_people_f.expense_check_send_to_address%TYPE;
3061: l_ni_number per_all_people_f.national_identifier%TYPE;
3062: l_sex per_all_people_f.sex%TYPE;
3063: l_pensioner_indicator VARCHAR2(1);
3064: l_aggregated_paye_flag VARCHAR2(1);

Line 3061: l_ni_number per_all_people_f.national_identifier%TYPE;

3057: l_middle_name per_all_people_f.middle_names%TYPE;
3058: l_date_of_birth DATE;
3059: l_title per_all_people_f.title%TYPE;
3060: l_expense_check_to_address per_all_people_f.expense_check_send_to_address%TYPE;
3061: l_ni_number per_all_people_f.national_identifier%TYPE;
3062: l_sex per_all_people_f.sex%TYPE;
3063: l_pensioner_indicator VARCHAR2(1);
3064: l_aggregated_paye_flag VARCHAR2(1);
3065: l_multiple_asg_flag VARCHAR2(1);

Line 3062: l_sex per_all_people_f.sex%TYPE;

3058: l_date_of_birth DATE;
3059: l_title per_all_people_f.title%TYPE;
3060: l_expense_check_to_address per_all_people_f.expense_check_send_to_address%TYPE;
3061: l_ni_number per_all_people_f.national_identifier%TYPE;
3062: l_sex per_all_people_f.sex%TYPE;
3063: l_pensioner_indicator VARCHAR2(1);
3064: l_aggregated_paye_flag VARCHAR2(1);
3065: l_multiple_asg_flag VARCHAR2(1);
3066: --

Line 3324: FROM per_all_people_f per

3320: substr(sex,1,1) sex ,
3321: decode(substr(per_information4,1,1),'Y','P',' ') pensioner_indicator,
3322: decode(per_information10,'Y','Y',NULL) agg_paye_flag,
3323: decode(per_information9,'Y','Y',NULL) multiple_asg_flag -- MII
3324: FROM per_all_people_f per
3325: WHERE per.person_id = p_person_id
3326: AND g_end_year BETWEEN per.effective_start_date
3327: AND per.effective_end_date;
3328: --

Line 3333: FROM per_all_people_f per

3329: cursor csr_director(p_person_id NUMBER) IS
3330: SELECT 'D'
3331: FROM dual
3332: WHERE EXISTS (SELECT '1'
3333: FROM per_all_people_f per
3334: WHERE p_person_id = per.person_id
3335: AND per.effective_start_date <= g_end_year
3336: AND per.effective_end_date >= g_start_year
3337: AND substr(per_information2,1,1) = 'Y')