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

Line 403: FROM per_all_people_f pap,

399:
400: -- to get the agg flag.
401: cursor csr_agg_flag(c_asg_id number) is
402: SELECT trim(nvl(pap.per_information10,'N')) per_agg_flag
403: FROM per_all_people_f pap,
404: per_all_assignments_f asg
405: WHERE asg.assignment_id = c_asg_id
406: AND pap.person_id = asg.person_id
407: AND asg.business_group_id = g_business_group_id

Line 1112: FROM per_all_people_f

1108:
1109: CURSOR csr_per_all_people
1110: IS
1111: SELECT l_column_name
1112: FROM per_all_people_f
1113: WHERE person_id = p_person_id
1114: AND ATTRIBUTE_CATEGORY = l_context_name
1115: ORDER BY effective_start_date,
1116: effective_end_date;

Line 1126: select max(effective_start_date) from per_all_people_f

1122: WHERE person_id = p_person_id
1123: AND PEI_INFORMATION_CATEGORY = l_context_name;
1124:
1125: cursor csr_per_start_date is
1126: select max(effective_start_date) from per_all_people_f
1127: where person_id = p_person_id
1128: and effective_start_date <= g_effective_date;
1129:
1130: BEGIN

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

1169:
1170: elsif l_source_name = 'PER_PEOPLE' THEN
1171: hr_utility.set_location('into PER_PEOPLE',1);
1172: sqlstr := 'select ' || l_column_name ||
1173: ' from per_all_people_f where person_id = :p_person_id and ATTRIBUTE_CATEGORY = :l_context_name' ||
1174: ' and :l_effective_date between effective_start_date and effective_end_date' ;
1175: hr_utility.trace(sqlstr);
1176: begin
1177: EXECUTE immediate sqlstr INTO l_passport_number USING p_person_id,l_context_name,l_effective_date;

Line 1260: per_all_people_f pap

1256: DECODE(pap.per_information10,'Y','Y',NULL) agg_paye_flag,
1257: DECODE(pap.per_information9,'Y','Y',NULL) multiple_asg_flag
1258: FROM pay_assignment_actions act,
1259: per_all_assignments_f paa,
1260: per_all_people_f pap
1261: WHERE act.assignment_action_id = p_assactid
1262: AND act.assignment_id = paa.assignment_id
1263: AND paa.person_id = pap.person_id
1264: AND p_end_date between pap.effective_start_date and pap.effective_end_date

Line 1510: FROM per_all_people_f pap,

1506: IS
1507: SELECT trim(NVL(pap.per_information9,'N')) per_ni_agg_flag,
1508: trim(NVL(pap.per_information10,'N')) per_agg_flag,
1509: asg.assignment_number assignment_number
1510: FROM per_all_people_f pap,
1511: per_all_assignments_f asg,
1512: pay_assignment_actions paa
1513: WHERE paa.assignment_action_id = c_asg_act_id
1514: AND paa.assignment_id = asg.assignment_id

Line 1643: select PER_INFORMATION2 from per_all_people_f papf

1639: and g_effective_date between peef.effective_start_date and peef.effective_end_date;
1640:
1641: -- Cursor to fetch Director details for the person
1642: cursor csr_director is
1643: select PER_INFORMATION2 from per_all_people_f papf
1644: where person_id = p_person_rec.person_id
1645: and effective_start_date =
1646: (select max(effective_start_date)
1647: from per_all_people_f where person_id = papf.person_id and effective_start_date <= g_effective_date);

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

1643: select PER_INFORMATION2 from per_all_people_f papf
1644: where person_id = p_person_rec.person_id
1645: and effective_start_date =
1646: (select max(effective_start_date)
1647: from per_all_people_f where person_id = papf.person_id and effective_start_date <= g_effective_date);
1648:
1649:
1650: l_starter_rec csr_get_starter_details%rowtype;
1651: l_pensioner_rec csr_get_pensioner_details%rowtype;

Line 2324: FROM per_all_people_f pap,

2320: IS
2321: SELECT trim(NVL(pap.per_information9,'N')) per_ni_agg_flag,
2322: trim(NVL(pap.per_information10,'N')) per_agg_flag,
2323: asg.assignment_number assignment_number
2324: FROM per_all_people_f pap,
2325: per_all_assignments_f asg
2326: WHERE asg.assignment_id = c_asg_act_id
2327: AND pap.person_id = asg.person_id
2328: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 3132: FROM per_all_people_f pap,

3128: SELECT trim(NVL(pap.per_information9,'N')) per_ni_agg_flag,
3129: trim(NVL(pap.per_information10,'N')) per_agg_flag,
3130: asg.assignment_number assignment_number,
3131: asg.assignment_id assignment_id
3132: FROM per_all_people_f pap,
3133: per_all_assignments_f asg,
3134: pay_assignment_actions paa
3135: WHERE paa.assignment_action_id = c_asg_act_id
3136: AND paa.assignment_id = asg.assignment_id

Line 3270: select PER_INFORMATION2 from per_all_people_f papf

3266: AND aei_information_category = 'GB_RTI_AGGREGATION';
3267:
3268: -- Cursor to fetch Director details for the person
3269: cursor csr_director is
3270: select PER_INFORMATION2 from per_all_people_f papf
3271: where person_id = p_person_rec.person_id
3272: and effective_start_date =
3273: (select max(effective_start_date)
3274: from per_all_people_f where person_id = papf.person_id and effective_start_date <= g_effective_date);

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

3270: select PER_INFORMATION2 from per_all_people_f papf
3271: where person_id = p_person_rec.person_id
3272: and effective_start_date =
3273: (select max(effective_start_date)
3274: from per_all_people_f where person_id = papf.person_id and effective_start_date <= g_effective_date);
3275:
3276: l_starter_rec csr_get_starter_details%rowtype;
3277: l_pensioner_rec csr_get_pensioner_details%rowtype;
3278: l_expat_rec csr_get_expat_details%rowtype;

Line 3975: FROM per_all_people_f pap,

3971: CURSOR csr_asg(c_asg_id NUMBER)
3972: IS
3973: SELECT trim(asg.primary_flag) asg_primary_flag,
3974: trim(pap.per_information10) per_agg_flag
3975: FROM per_all_people_f pap,
3976: per_all_assignments_f asg
3977: WHERE asg.assignment_id = c_asg_id
3978: AND pap.person_id = asg.person_id
3979: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 4237: FROM per_all_people_f pap,

4233: CURSOR csr_asg(c_asg_id NUMBER)
4234: IS
4235: SELECT trim(asg.primary_flag) asg_primary_flag,
4236: trim(pap.per_information10) per_agg_flag
4237: FROM per_all_people_f pap,
4238: per_all_assignments_f asg
4239: WHERE asg.assignment_id = c_asg_id
4240: AND pap.person_id = asg.person_id
4241: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 4476: FROM per_all_people_f pap,

4472: CURSOR csr_asg(c_asg_id NUMBER, c_effective_date DATE)
4473: IS
4474: SELECT trim(asg.primary_flag) asg_primary_flag,
4475: trim(pap.per_information10) per_agg_flag
4476: FROM per_all_people_f pap,
4477: per_all_assignments_f asg
4478: WHERE asg.assignment_id = c_asg_id
4479: AND pap.person_id = asg.person_id
4480: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 5142: FROM per_all_people_f pap,

5138: CURSOR csr_asg(c_asg_id NUMBER, c_effective_date DATE)
5139: IS
5140: SELECT trim(asg.primary_flag) asg_primary_flag,
5141: trim(pap.per_information10) per_agg_flag
5142: FROM per_all_people_f pap,
5143: per_all_assignments_f asg
5144: WHERE asg.assignment_id = c_asg_id
5145: AND pap.person_id = asg.person_id
5146: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 6180: FROM per_all_people_f pap,

6176: trim(asg.primary_flag) asg_primary_flag,
6177: trim(nvl(pap.per_information10,'N')) per_agg_flag,
6178: trim(nvl(pap.per_information9,'N')) ni_agg_flag,
6179: asg.assignment_number
6180: FROM per_all_people_f pap,
6181: per_all_assignments_f asg
6182: WHERE asg.assignment_id = c_asg_id
6183: AND pap.person_id = asg.person_id
6184: AND asg.business_group_id = l_business_group_id

Line 6247: from per_all_people_f pap,

6243: select distinct paaf.assignment_id assignment_id,
6244: trim(paaf.primary_flag) asg_primary_flag,
6245: trim(pap.per_information10) per_agg_flag,
6246: pap.person_id
6247: from per_all_people_f pap,
6248: per_all_assignments_f paaf,
6249: per_assignment_status_types past --,
6250: --pay_payroll_actions paa
6251: where pap.person_id between stperson and endperson

Line 6261: per_all_people_f pap2

6257: and paaf.business_group_id = l_bus_grp_id --paa.business_group_id
6258: and paaf.payroll_id = l_prl_id --paa.payroll_id
6259: and pap.effective_start_date =
6260: ( select max(pap2.effective_start_date) from
6261: per_all_people_f pap2
6262: where pap2.person_id = pap.person_id
6263: and pap2.effective_start_date <= p_prepayment_date
6264: )
6265: and paaf.effective_start_date =

Line 8182: FROM per_all_people_f pap,

8178: SELECT trim(NVL(asg.primary_flag,'N')) asg_primary_flag,
8179: trim(NVL(pap.per_information9,'N')) per_ni_agg_flag,
8180: trim(NVL(pap.per_information10,'N')) per_paye_agg_flag,
8181: asg.payroll_id payroll_id
8182: FROM per_all_people_f pap,
8183: per_all_assignments_f asg,
8184: pay_assignment_actions paa
8185: WHERE paa.assignment_action_id = c_asg_act_id
8186: AND paa.assignment_id = asg.assignment_id

Line 12667: per_all_people_f pap

12663: paa.EFFECTIVE_END_DATE end_date, --to_char(paa.EFFECTIVE_END_DATE,'DD-MON-RRRR') end_date
12664: pap.person_id
12665: FROM per_all_assignments_f paa,
12666: per_assignment_status_types past,
12667: per_all_people_f pap
12668: WHERE paa.person_id = pap.person_id
12669: AND paa.assignment_id = c_assignment_id
12670: AND past.ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID
12671: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN') -- Added for Bug#13626488

Line 12674: per_all_people_f pap2

12670: AND past.ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID
12671: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN') -- Added for Bug#13626488
12672: and pap.effective_start_date =
12673: ( select max(pap2.effective_start_date) from
12674: per_all_people_f pap2
12675: where pap2.person_id = pap.person_id
12676: and pap2.effective_start_date <= l_effective_date
12677: )
12678: and paa.effective_start_date =