APPS.PAY_JP_DEF_SS dependencies on PER_ALL_PEOPLE_F

Line 137: l_full_name per_all_people_f.full_name%type;

133: function full_name(
134: p_person_id in number,
135: p_effective_date in date) return varchar2
136: is
137: l_full_name per_all_people_f.full_name%type;
138: cursor csr_full_name is
139: select trim(per_information18 || ' ' || per_information19)
140: from per_all_people_f
141: where person_id = p_person_id

Line 140: from per_all_people_f

136: is
137: l_full_name per_all_people_f.full_name%type;
138: cursor csr_full_name is
139: select trim(per_information18 || ' ' || per_information19)
140: from per_all_people_f
141: where person_id = p_person_id
142: and p_effective_date
143: between effective_start_date and effective_end_date;
144: cursor csr_full_name2 is

Line 146: from per_all_people_f

142: and p_effective_date
143: between effective_start_date and effective_end_date;
144: cursor csr_full_name2 is
145: select trim(per_information18 || ' ' || per_information19)
146: from per_all_people_f
147: where person_id = p_person_id
148: and start_date = effective_start_date;
149: begin
150: if p_person_id is not null then

Line 1575: per_all_people_f per,

1571: adrc.address_line1 || adrc.address_line2 || adrc.address_line3,
1572: adrr.address_line1 || adrr.address_line2 || adrr.address_line3), 1, 240)) address,
1573: decode(adrr.address_id,null,adrc.town_or_city,adrr.town_or_city) district_code
1574: from per_all_assignments_f asg,
1575: per_all_people_f per,
1576: per_addresses adrr,
1577: per_addresses adrc
1578: where asg.assignment_id = p_assignment_id
1579: and p_effective_date

Line 1643: per_all_people_f per

1639: from per_contact_relationships ctr,
1640: per_contact_extra_info_f cei,
1641: per_addresses adrr,
1642: per_addresses adrc,
1643: per_all_people_f per
1644: where ctr.person_id = p_person_id
1645: and cei.contact_relationship_id = ctr.contact_relationship_id
1646: and cei.cei_information_category = 'JP_ITAX_DEPENDENT'
1647: and p_effective_date

Line 1697: per_all_people_f per,

1693: from per_contact_relationships ctr,
1694: per_contact_extra_info_f cei,
1695: per_addresses adrr,
1696: per_addresses adrc,
1697: per_all_people_f per,
1698: per_contact_relationships ctr2,
1699: per_addresses adrr2,
1700: per_addresses adrc2
1701: where ctr.person_id = p_person_id

Line 1750: from per_all_people_f per,

1746: per.date_of_death,
1747: cei.cei_information1 OCCUPATION,
1748: cei.cei_information2 OS_SALARY_PAYER_NAME,
1749: cei.cei_information3 OS_SALARY_PAYER_ADDRESS
1750: from per_all_people_f per,
1751: per_contact_extra_info_f cei,
1752: per_contact_relationships ctr
1753: where ctr.person_id = p_person_id
1754: and cei.contact_relationship_id = ctr.contact_relationship_id

Line 3178: from per_all_people_f per,

3174: select assact.action_information_id,
3175: assact.object_version_number,
3176: per.full_name,
3177: asg.assignment_number
3178: from per_all_people_f per,
3179: per_all_assignments_f asg,
3180: pay_jp_def_assact_v assact,
3181: pay_assignment_actions paa
3182: where paa.payroll_action_id = l_payroll_action_id