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

Line 305: FROM per_all_people_f

301:
302: CURSOR csr_per_all_people
303: IS
304: SELECT l_column_name
305: FROM per_all_people_f
306: WHERE person_id = p_person_id
307: AND ATTRIBUTE_CATEGORY = l_context_name
308: AND p_effective_date between effective_start_date and effective_end_date;
309:

Line 318: select max(effective_start_date) from per_all_people_f

314: WHERE person_id = p_person_id
315: AND PEI_INFORMATION_CATEGORY = l_context_name;
316:
317: cursor csr_per_start_date is
318: select max(effective_start_date) from per_all_people_f
319: where person_id = p_person_id
320: and effective_start_date <= p_effective_date;
321:
322: BEGIN

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

361:
362: elsif l_source_name = 'PER_PEOPLE' THEN
363: hr_utility.set_location('into PER_PEOPLE',1);
364: sqlstr := 'select ' || l_column_name ||
365: ' from per_all_people_f where person_id = :p_person_id and ATTRIBUTE_CATEGORY = :l_context_name' ||
366: ' and :l_effective_date between effective_start_date and effective_end_date' ;
367: hr_utility.trace(sqlstr);
368: begin
369: EXECUTE immediate sqlstr INTO l_passport_number USING p_person_id,l_context_name,l_effective_date;

Line 452: per_all_people_f pap

448: DECODE(pap.per_information9,'Y','Y',NULL) multiple_asg_flag,
449: pap.business_group_id business_group_id
450: FROM pay_assignment_actions act,
451: per_all_assignments_f paa,
452: per_all_people_f pap
453: WHERE act.assignment_action_id = p_assactid
454: AND act.assignment_id = paa.assignment_id
455: AND paa.person_id = pap.person_id
456: AND p_effective_date between pap.effective_start_date and pap.effective_end_date

Line 942: FROM per_all_people_f pap,

938: CURSOR csr_asg(c_asg_id NUMBER, c_effective_date DATE)
939: IS
940: SELECT trim(asg.primary_flag) asg_primary_flag,
941: trim(pap.per_information10) per_agg_flag
942: FROM per_all_people_f pap,
943: per_all_assignments_f asg
944: WHERE asg.assignment_id = c_asg_id
945: AND pap.person_id = asg.person_id
946: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 1290: FROM per_all_people_f pap,

1286: IS
1287: SELECT trim(asg.primary_flag) asg_primary_flag,
1288: trim(pap.per_information10) per_agg_flag,
1289: trim(pap.per_information9) per_ni_flag
1290: FROM per_all_people_f pap,
1291: per_all_assignments_f asg
1292: WHERE asg.assignment_id = c_asg_id
1293: AND pap.person_id = asg.person_id
1294: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 3797: sqlstr := 'select distinct PERSON_ID '|| 'from per_all_people_f ppf, '

3793:
3794: BEGIN
3795: hr_utility.set_location('Entering: '||l_proc,1);
3796:
3797: sqlstr := 'select distinct PERSON_ID '|| 'from per_all_people_f ppf, '
3798: || 'pay_payroll_actions ppa '|| 'where ppa.payroll_action_id = :payroll_action_id '
3799: || 'and ppa.business_group_id = ppf.business_group_id '
3800: || ' order by person_id';
3801:

Line 3851: from per_all_people_f pap,

3847:
3848: CURSOR csr_asg is
3849: select distinct asg.assignment_id assignment_id,trim(pap.per_information10) per_agg_flag,trim(pap.per_information9) per_ni_flag,
3850: pap.person_id person_id , asg.assignment_number l_asg_num
3851: from per_all_people_f pap,
3852: per_all_assignments_f asg,
3853: per_assignment_status_types past,
3854: pay_all_payrolls_f pay,
3855: hr_soft_coding_keyflex sck

Line 5353: per_all_people_f pap

5349: trim(NVL(pap.per_information10,'N')) per_paye_agg_flag,
5350: assignment_number
5351: from pay_assignment_actions paa,
5352: per_all_assignments_f paaf,
5353: per_all_people_f pap
5354: where assignment_action_id = p_assactid
5355: and paaf.assignment_id = paa.assignment_id
5356: and pap.person_id = paaf.person_id
5357: and paaf.effective_start_date =

Line 6007: per_all_people_f pap

6003: paa.EFFECTIVE_END_DATE end_date, --to_char(paa.EFFECTIVE_END_DATE,'DD-MON-RRRR') end_date
6004: pap.person_id
6005: FROM per_all_assignments_f paa,
6006: per_assignment_status_types past,
6007: per_all_people_f pap
6008: WHERE paa.person_id = pap.person_id
6009: AND paa.assignment_id = c_assignment_id
6010: AND past.ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID
6011: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN') -- Added for Bug#13626488

Line 6014: per_all_people_f pap2

6010: AND past.ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID
6011: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN') -- Added for Bug#13626488
6012: and pap.effective_start_date =
6013: ( select max(pap2.effective_start_date) from
6014: per_all_people_f pap2
6015: where pap2.person_id = pap.person_id
6016: and pap2.effective_start_date <= g_end_year
6017: )
6018: and paa.effective_start_date =