APPS.PQP_GB_PSI_ADDDRESS dependencies on PER_ADDRESSES

Line 16: g_business_group_id per_addresses.business_group_id%TYPE;

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;
19: g_current_run VARCHAR2(20);
20: g_current_layout VARCHAR2(20);

Line 24: g_office_address_type per_addresses.address_type%TYPE;

20: g_current_layout VARCHAR2(20);
21:
22: g_pay_proc_evt_tab ben_ext_person.t_detailed_output_table;
23:
24: g_office_address_type per_addresses.address_type%TYPE;
25: g_home_address_type per_addresses.address_type%TYPE;
26: g_office_address_id per_addresses.address_id%TYPE;
27: g_home_address_id per_addresses.address_id%TYPE;
28:

Line 25: g_home_address_type per_addresses.address_type%TYPE;

21:
22: g_pay_proc_evt_tab ben_ext_person.t_detailed_output_table;
23:
24: g_office_address_type per_addresses.address_type%TYPE;
25: g_home_address_type per_addresses.address_type%TYPE;
26: g_office_address_id per_addresses.address_id%TYPE;
27: g_home_address_id per_addresses.address_id%TYPE;
28:
29: g_country VARCHAR2(30);

Line 26: g_office_address_id per_addresses.address_id%TYPE;

22: g_pay_proc_evt_tab ben_ext_person.t_detailed_output_table;
23:
24: g_office_address_type per_addresses.address_type%TYPE;
25: g_home_address_type per_addresses.address_type%TYPE;
26: g_office_address_id per_addresses.address_id%TYPE;
27: g_home_address_id per_addresses.address_id%TYPE;
28:
29: g_country VARCHAR2(30);
30:

Line 27: g_home_address_id per_addresses.address_id%TYPE;

23:
24: g_office_address_type per_addresses.address_type%TYPE;
25: g_home_address_type per_addresses.address_type%TYPE;
26: g_office_address_id per_addresses.address_id%TYPE;
27: g_home_address_id per_addresses.address_id%TYPE;
28:
29: g_country VARCHAR2(30);
30:
31: g_office_address_changed VARCHAR2(1);-- this is used by the data elements functions

Line 74: FROM per_addresses pa

70: ,pa.telephone_number_1
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