APPS.PQP_HRTCA_SYNCHRONIZATION dependencies on PER_ALL_PEOPLE_F

Line 22: FROM per_all_people_f ppf

18:
19: -- Get person party id
20: CURSOR csr_partyid (c_person_id IN Number) IS
21: SELECT ppf.party_id,pbg.legislation_code
22: FROM per_all_people_f ppf
23: ,per_business_groups_perf pbg
24: WHERE ppf.person_id = c_person_id
25: AND pbg.business_group_id = ppf.business_group_id;
26:

Line 74: l_party_id per_all_people_f.party_id%TYPE;

70: ,p_pei_information29 IN Varchar2
71: ,p_pei_information30 IN Varchar2
72: ) AS
73: l_return_flag Boolean;
74: l_party_id per_all_people_f.party_id%TYPE;
75: l_bg_code per_business_groups.legislation_code%TYPE;
76: l_Stu_OSSData_Sync Varchar2(5);
77:
78: l_pei_rec per_people_extra_info%ROWTYPE;

Line 253: l_party_id per_all_people_f.party_id%TYPE;

249: ,p_pei_information30_o IN Varchar2
250: ) AS
251:
252: l_return_flag Boolean;
253: l_party_id per_all_people_f.party_id%TYPE;
254: l_Stu_OSSData_Sync Varchar2(5);
255: l_bg_code per_business_groups.legislation_code%TYPE;
256: l_pei_rec_new per_people_extra_info%ROWTYPE;
257: l_pei_rec_old per_people_extra_info%ROWTYPE;