APPS.PAY_JP_DEF_SS dependencies on PER_ALL_PEOPLE_F

Line 130: l_full_name per_all_people_f.full_name%type;

126: function full_name(
127: p_person_id in number,
128: p_effective_date in date) return varchar2
129: is
130: l_full_name per_all_people_f.full_name%type;
131: cursor csr_full_name is
132: select trim(per_information18 || ' ' || per_information19)
133: from per_all_people_f
134: where person_id = p_person_id

Line 133: from per_all_people_f

129: is
130: l_full_name per_all_people_f.full_name%type;
131: cursor csr_full_name is
132: select trim(per_information18 || ' ' || per_information19)
133: from per_all_people_f
134: where person_id = p_person_id
135: and p_effective_date
136: between effective_start_date and effective_end_date;
137: cursor csr_full_name2 is

Line 139: from per_all_people_f

135: and p_effective_date
136: between effective_start_date and effective_end_date;
137: cursor csr_full_name2 is
138: select trim(per_information18 || ' ' || per_information19)
139: from per_all_people_f
140: where person_id = p_person_id
141: and start_date = effective_start_date;
142: begin
143: if p_person_id is not null then

Line 1286: per_all_people_f per,

1282: adrr.address_line1 || adrr.address_line2 || adrr.address_line3), 1, 240))
1283: address
1284: from per_addresses adrc,
1285: per_addresses adrr,
1286: per_all_people_f per,
1287: per_all_assignments_f asg
1288: where asg.assignment_id = p_assignment_id
1289: and p_effective_date
1290: between asg.effective_start_date and asg.effective_end_date

Line 1376: from per_all_people_f per,

1372: cei.cei_information2 OCCUPATION,
1373: fnd_number.canonical_to_number(cei.cei_information3) ESTIMATED_ANNUAL_INCOME,
1374: cei.cei_information6 DISABILITY_TYPE,
1375: cei.cei_information7 DISABILITY_DETAILS
1376: from per_all_people_f per,
1377: per_addresses adrc,
1378: per_addresses adrr,
1379: per_contact_extra_info_f cei,
1380: per_contact_relationships ctr

Line 1434: per_all_people_f per,

1430: OE_ADDRESS
1431: from per_addresses adrc2,
1432: per_addresses adrr2,
1433: per_contact_relationships ctr2,
1434: per_all_people_f per,
1435: per_addresses adrc,
1436: per_addresses adrr,
1437: per_contact_extra_info_f cei,
1438: per_contact_relationships ctr

Line 1488: from per_all_people_f per,

1484: per.date_of_death,
1485: cei.cei_information1 OCCUPATION,
1486: cei.cei_information2 OS_SALARY_PAYER_NAME,
1487: cei.cei_information3 OS_SALARY_PAYER_ADDRESS
1488: from per_all_people_f per,
1489: per_contact_extra_info_f cei,
1490: per_contact_relationships ctr
1491: where ctr.person_id = p_person_id
1492: and cei.contact_relationship_id = ctr.contact_relationship_id

Line 2472: from per_all_people_f per,

2468: select assact.action_information_id,
2469: assact.object_version_number,
2470: per.full_name,
2471: asg.assignment_number
2472: from per_all_people_f per,
2473: per_all_assignments_f asg,
2474: pay_jp_def_assact_v assact,
2475: pay_assignment_actions paa
2476: where paa.payroll_action_id = l_payroll_action_id