APPS.PQP_GB_PSI_ADDDRESS dependencies on PER_ALL_PEOPLE_F

Line 14: g_person_id per_all_people_f.person_id%type;

10: -- address mapping configuration name
11: c_highest_date CONSTANT DATE := to_date('31/12/4712','DD/MM/YYYY');
12: -- highest date
13:
14: g_person_id per_all_people_f.person_id%type;
15: g_assignment_id NUMBER;
16: g_business_group_id per_addresses.business_group_id%TYPE;
17: g_legislation_code VARCHAR2(2);
18: g_effective_date DATE;

Line 36: g_email_address per_all_people_f.email_address%TYPE;

32: -- to check if there is a change in office address
33: g_home_address_changed VARCHAR2(1);-- this is used by the data elements functions
34: -- to check if there is a change in home address
35:
36: g_email_address per_all_people_f.email_address%TYPE;
37: g_curr_person_dtls per_all_people_f%ROWTYPE;-- current perons details fetched from the
38: -- shared globals
39: g_curr_assg_dtls per_all_assignments_f%ROWTYPE;-- current assignment details fetched from the
40: -- shared globals

Line 37: g_curr_person_dtls per_all_people_f%ROWTYPE;-- current perons details fetched from the

33: g_home_address_changed VARCHAR2(1);-- this is used by the data elements functions
34: -- to check if there is a change in home address
35:
36: g_email_address per_all_people_f.email_address%TYPE;
37: g_curr_person_dtls per_all_people_f%ROWTYPE;-- current perons details fetched from the
38: -- shared globals
39: g_curr_assg_dtls per_all_assignments_f%ROWTYPE;-- current assignment details fetched from the
40: -- shared globals
41: g_paypoint VARCHAR2(30);-- paypoint value fetched from

Line 75: ,per_all_people_f ppf

71: ,pa.telephone_number_2
72: ,ppf.email_address
73: ,ppf.mailstop
74: FROM per_addresses pa
75: ,per_all_people_f ppf
76: ,fnd_territories_tl ftt
77: ,fnd_common_lookups fcl
78: ,HR_LOOKUPS hrl
79: WHERE pa.person_id = ppf.person_id

Line 105: FROM per_all_people_f

101: CURSOR csr_get_email_mailstop
102: IS
103: SELECT email_address
104: ,mailstop
105: FROM per_all_people_f
106: WHERE person_id = g_person_id
107: AND g_effective_date BETWEEN effective_start_date
108: AND effective_end_date;
109: