APPS.PAY_US_RULES dependencies on PER_ADDRESSES

Line 272: from per_addresses addr,

268: select nvl(addr.add_information17,addr.region_2),
269: nvl(addr.add_information19,addr.region_1),
270: nvl(addr.add_information18,addr.town_or_city),
271: nvl(addr.add_information20,addr.postal_code)
272: from per_addresses addr,
273: per_all_assignments_f assign,
274: pay_assignment_actions paa
275: where paa.assignment_id = assign.assignment_id
276: and paa.assignment_action_id = p_asg_act_id

Line 310: l_override_adr_region_2 per_addresses.add_information17%type;

306: l_asg_wrk_at_home varchar2(1);
307: l_ele_classification pay_element_classifications.classification_name%type;
308: l_proc_name varchar2(50);
309:
310: l_override_adr_region_2 per_addresses.add_information17%type;
311: l_override_adr_region_1 per_addresses.add_information17%type;
312: l_override_adr_city per_addresses.add_information17%type;
313: l_override_adr_postal_code per_addresses.add_information17%type;
314:

Line 311: l_override_adr_region_1 per_addresses.add_information17%type;

307: l_ele_classification pay_element_classifications.classification_name%type;
308: l_proc_name varchar2(50);
309:
310: l_override_adr_region_2 per_addresses.add_information17%type;
311: l_override_adr_region_1 per_addresses.add_information17%type;
312: l_override_adr_city per_addresses.add_information17%type;
313: l_override_adr_postal_code per_addresses.add_information17%type;
314:
315: BEGIN

Line 312: l_override_adr_city per_addresses.add_information17%type;

308: l_proc_name varchar2(50);
309:
310: l_override_adr_region_2 per_addresses.add_information17%type;
311: l_override_adr_region_1 per_addresses.add_information17%type;
312: l_override_adr_city per_addresses.add_information17%type;
313: l_override_adr_postal_code per_addresses.add_information17%type;
314:
315: BEGIN
316: l_pkg_name := 'pay_us_rules.';

Line 313: l_override_adr_postal_code per_addresses.add_information17%type;

309:
310: l_override_adr_region_2 per_addresses.add_information17%type;
311: l_override_adr_region_1 per_addresses.add_information17%type;
312: l_override_adr_city per_addresses.add_information17%type;
313: l_override_adr_postal_code per_addresses.add_information17%type;
314:
315: BEGIN
316: l_pkg_name := 'pay_us_rules.';
317: l_proc_name := l_pkg_name||'default_jurisdiction';