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

Line 278: FROM per_all_people_f pap,

274:
275: -- to get the agg flag.
276: cursor csr_agg_flag(c_asg_id number) is
277: SELECT trim(nvl(pap.per_information10,'N')) per_agg_flag
278: FROM per_all_people_f pap,
279: per_all_assignments_f asg
280: WHERE asg.assignment_id = c_asg_id
281: AND pap.person_id = asg.person_id
282: AND asg.business_group_id = g_business_group_id

Line 1412: FROM per_all_people_f

1408:
1409: CURSOR csr_per_all_people
1410: IS
1411: SELECT l_column_name
1412: FROM per_all_people_f
1413: WHERE person_id = p_person_id
1414: AND ATTRIBUTE_CATEGORY = l_context_name
1415: ORDER BY effective_start_date,
1416: effective_end_date;

Line 1426: select max(effective_start_date) from per_all_people_f

1422: WHERE person_id = p_person_id
1423: AND PEI_INFORMATION_CATEGORY = l_context_name;
1424:
1425: cursor csr_per_start_date is
1426: select max(effective_start_date) from per_all_people_f
1427: where person_id = p_person_id
1428: and effective_start_date <= g_effective_date;
1429:
1430: BEGIN

Line 1473: ' from per_all_people_f where person_id = :p_person_id and ATTRIBUTE_CATEGORY = :l_context_name' ||

1469:
1470: elsif l_source_name = 'PER_PEOPLE' THEN
1471: hr_utility.set_location('into PER_PEOPLE',1);
1472: sqlstr := 'select ' || l_column_name ||
1473: ' from per_all_people_f where person_id = :p_person_id and ATTRIBUTE_CATEGORY = :l_context_name' ||
1474: ' and :l_effective_date between effective_start_date and effective_end_date' ;
1475: hr_utility.trace(sqlstr);
1476: begin
1477: EXECUTE immediate sqlstr INTO l_passport_number USING p_person_id,l_context_name,l_effective_date;

Line 1770: per_all_people_f pap

1766: DECODE(pap.per_information10,'Y','Y',NULL) agg_paye_flag,
1767: DECODE(pap.per_information9,'Y','Y',NULL) multiple_asg_flag
1768: FROM pay_assignment_actions act,
1769: per_all_assignments_f paa,
1770: per_all_people_f pap
1771: WHERE act.assignment_action_id = p_assactid
1772: AND act.assignment_id = paa.assignment_id
1773: AND paa.person_id = pap.person_id
1774: AND p_end_date between pap.effective_start_date and pap.effective_end_date

Line 2020: FROM per_all_people_f pap,

2016: IS
2017: SELECT trim(NVL(pap.per_information9,'N')) per_ni_agg_flag,
2018: trim(NVL(pap.per_information10,'N')) per_agg_flag,
2019: asg.assignment_number assignment_number
2020: FROM per_all_people_f pap,
2021: per_all_assignments_f asg,
2022: pay_assignment_actions paa
2023: WHERE paa.assignment_action_id = c_asg_act_id
2024: AND paa.assignment_id = asg.assignment_id

Line 2148: select PER_INFORMATION2 from per_all_people_f papf

2144: and g_effective_date between peef.effective_start_date and peef.effective_end_date;
2145:
2146: -- Cursor to fetch Director details for the person
2147: cursor csr_director is
2148: select PER_INFORMATION2 from per_all_people_f papf
2149: where person_id = p_person_rec.person_id
2150: and effective_start_date =
2151: (select max(effective_start_date)
2152: from per_all_people_f where person_id = papf.person_id and effective_start_date <= g_effective_date);

Line 2152: from per_all_people_f where person_id = papf.person_id and effective_start_date <= g_effective_date);

2148: select PER_INFORMATION2 from per_all_people_f papf
2149: where person_id = p_person_rec.person_id
2150: and effective_start_date =
2151: (select max(effective_start_date)
2152: from per_all_people_f where person_id = papf.person_id and effective_start_date <= g_effective_date);
2153:
2154:
2155: l_starter_rec csr_get_starter_details%rowtype;
2156: l_pensioner_rec csr_get_pensioner_details%rowtype;

Line 2802: FROM per_all_people_f pap,

2798: IS
2799: SELECT trim(NVL(pap.per_information9,'N')) per_ni_agg_flag,
2800: trim(NVL(pap.per_information10,'N')) per_agg_flag,
2801: asg.assignment_number assignment_number
2802: FROM per_all_people_f pap,
2803: per_all_assignments_f asg
2804: WHERE asg.assignment_id = c_asg_act_id
2805: AND pap.person_id = asg.person_id
2806: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 3599: FROM per_all_people_f pap,

3595: SELECT trim(NVL(pap.per_information9,'N')) per_ni_agg_flag,
3596: trim(NVL(pap.per_information10,'N')) per_agg_flag,
3597: asg.assignment_number assignment_number,
3598: asg.assignment_id assignment_id
3599: FROM per_all_people_f pap,
3600: per_all_assignments_f asg,
3601: pay_assignment_actions paa
3602: WHERE paa.assignment_action_id = c_asg_act_id
3603: AND paa.assignment_id = asg.assignment_id

Line 3732: select PER_INFORMATION2 from per_all_people_f papf

3728: AND aei_information_category = 'GB_RTI_AGGREGATION';
3729:
3730: -- Cursor to fetch Director details for the person
3731: cursor csr_director is
3732: select PER_INFORMATION2 from per_all_people_f papf
3733: where person_id = p_person_rec.person_id
3734: and effective_start_date =
3735: (select max(effective_start_date)
3736: from per_all_people_f where person_id = papf.person_id and effective_start_date <= g_effective_date);

Line 3736: from per_all_people_f where person_id = papf.person_id and effective_start_date <= g_effective_date);

3732: select PER_INFORMATION2 from per_all_people_f papf
3733: where person_id = p_person_rec.person_id
3734: and effective_start_date =
3735: (select max(effective_start_date)
3736: from per_all_people_f where person_id = papf.person_id and effective_start_date <= g_effective_date);
3737:
3738: l_starter_rec csr_get_starter_details%rowtype;
3739: l_pensioner_rec csr_get_pensioner_details%rowtype;
3740: l_expat_rec csr_get_expat_details%rowtype;

Line 4551: FROM per_all_people_f pap,

4547: CURSOR csr_asg(c_asg_id NUMBER)
4548: IS
4549: SELECT trim(asg.primary_flag) asg_primary_flag,
4550: trim(pap.per_information10) per_agg_flag
4551: FROM per_all_people_f pap,
4552: per_all_assignments_f asg
4553: WHERE asg.assignment_id = c_asg_id
4554: AND pap.person_id = asg.person_id
4555: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 4824: FROM per_all_people_f pap,

4820: CURSOR csr_asg(c_asg_id NUMBER)
4821: IS
4822: SELECT trim(asg.primary_flag) asg_primary_flag,
4823: trim(pap.per_information10) per_agg_flag
4824: FROM per_all_people_f pap,
4825: per_all_assignments_f asg
4826: WHERE asg.assignment_id = c_asg_id
4827: AND pap.person_id = asg.person_id
4828: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 5074: FROM per_all_people_f pap,

5070: CURSOR csr_asg(c_asg_id NUMBER, c_effective_date DATE)
5071: IS
5072: SELECT trim(asg.primary_flag) asg_primary_flag,
5073: trim(pap.per_information10) per_agg_flag
5074: FROM per_all_people_f pap,
5075: per_all_assignments_f asg
5076: WHERE asg.assignment_id = c_asg_id
5077: AND pap.person_id = asg.person_id
5078: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 5756: FROM per_all_people_f pap,

5752: CURSOR csr_asg(c_asg_id NUMBER, c_effective_date DATE)
5753: IS
5754: SELECT trim(asg.primary_flag) asg_primary_flag,
5755: trim(pap.per_information10) per_agg_flag
5756: FROM per_all_people_f pap,
5757: per_all_assignments_f asg
5758: WHERE asg.assignment_id = c_asg_id
5759: AND pap.person_id = asg.person_id
5760: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 6851: FROM per_all_people_f pap,

6847: trim(asg.primary_flag) asg_primary_flag,
6848: trim(nvl(pap.per_information10,'N')) per_agg_flag,
6849: trim(nvl(pap.per_information9,'N')) ni_agg_flag,
6850: asg.assignment_number
6851: FROM per_all_people_f pap,
6852: per_all_assignments_f asg
6853: WHERE asg.assignment_id = c_asg_id
6854: AND pap.person_id = asg.person_id
6855: AND asg.business_group_id = l_business_group_id

Line 6916: from per_all_people_f pap,

6912: select distinct paaf.assignment_id assignment_id,
6913: trim(paaf.primary_flag) asg_primary_flag,
6914: trim(pap.per_information10) per_agg_flag,
6915: pap.person_id
6916: from per_all_people_f pap,
6917: per_all_assignments_f paaf,
6918: per_assignment_status_types past,
6919: pay_payroll_actions paa
6920: where pap.person_id between stperson and endperson

Line 6930: per_all_people_f pap2

6926: and paaf.business_group_id = paa.business_group_id
6927: and paaf.payroll_id = paa.payroll_id
6928: and pap.effective_start_date =
6929: ( select max(pap2.effective_start_date) from
6930: per_all_people_f pap2
6931: where pap2.person_id = pap.person_id
6932: and pap2.effective_start_date <= p_prepayment_date
6933: )
6934: and paaf.effective_start_date =

Line 8816: FROM per_all_people_f pap,

8812: SELECT trim(NVL(asg.primary_flag,'N')) asg_primary_flag,
8813: trim(NVL(pap.per_information9,'N')) per_ni_agg_flag,
8814: trim(NVL(pap.per_information10,'N')) per_paye_agg_flag,
8815: asg.payroll_id payroll_id
8816: FROM per_all_people_f pap,
8817: per_all_assignments_f asg,
8818: pay_assignment_actions paa
8819: WHERE paa.assignment_action_id = c_asg_act_id
8820: AND paa.assignment_id = asg.assignment_id

Line 13422: per_all_people_f pap

13418: paa.EFFECTIVE_END_DATE end_date, --to_char(paa.EFFECTIVE_END_DATE,'DD-MON-RRRR') end_date
13419: pap.person_id
13420: FROM per_all_assignments_f paa,
13421: per_assignment_status_types past,
13422: per_all_people_f pap
13423: WHERE paa.person_id = pap.person_id
13424: AND paa.assignment_id = c_assignment_id
13425: AND past.ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID
13426: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN') -- Added for Bug#13626488

Line 13429: per_all_people_f pap2

13425: AND past.ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID
13426: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN') -- Added for Bug#13626488
13427: and pap.effective_start_date =
13428: ( select max(pap2.effective_start_date) from
13429: per_all_people_f pap2
13430: where pap2.person_id = pap.person_id
13431: and pap2.effective_start_date <= l_effective_date
13432: )
13433: and paa.effective_start_date =