APPS.PAY_US_RULES dependencies on PER_ADDRESSES

Line 217: from per_addresses addr,

213: select nvl(addr.add_information17,addr.region_2),
214: nvl(addr.add_information19,addr.region_1),
215: nvl(addr.add_information18,addr.town_or_city),
216: nvl(addr.add_information20,addr.postal_code)
217: from per_addresses addr,
218: per_all_assignments_f assign,
219: pay_assignment_actions paa
220: where paa.assignment_id = assign.assignment_id
221: and paa.assignment_action_id = p_asg_act_id

Line 255: l_override_adr_region_2 per_addresses.add_information17%type;

251: l_asg_wrk_at_home varchar2(1);
252: l_ele_classification pay_element_classifications.classification_name%type;
253: l_proc_name varchar2(50);
254:
255: l_override_adr_region_2 per_addresses.add_information17%type;
256: l_override_adr_region_1 per_addresses.add_information17%type;
257: l_override_adr_city per_addresses.add_information17%type;
258: l_override_adr_postal_code per_addresses.add_information17%type;
259:

Line 256: l_override_adr_region_1 per_addresses.add_information17%type;

252: l_ele_classification pay_element_classifications.classification_name%type;
253: l_proc_name varchar2(50);
254:
255: l_override_adr_region_2 per_addresses.add_information17%type;
256: l_override_adr_region_1 per_addresses.add_information17%type;
257: l_override_adr_city per_addresses.add_information17%type;
258: l_override_adr_postal_code per_addresses.add_information17%type;
259:
260: BEGIN

Line 257: l_override_adr_city per_addresses.add_information17%type;

253: l_proc_name varchar2(50);
254:
255: l_override_adr_region_2 per_addresses.add_information17%type;
256: l_override_adr_region_1 per_addresses.add_information17%type;
257: l_override_adr_city per_addresses.add_information17%type;
258: l_override_adr_postal_code per_addresses.add_information17%type;
259:
260: BEGIN
261: l_pkg_name := 'pay_us_rules.';

Line 258: l_override_adr_postal_code per_addresses.add_information17%type;

254:
255: l_override_adr_region_2 per_addresses.add_information17%type;
256: l_override_adr_region_1 per_addresses.add_information17%type;
257: l_override_adr_city per_addresses.add_information17%type;
258: l_override_adr_postal_code per_addresses.add_information17%type;
259:
260: BEGIN
261: l_pkg_name := 'pay_us_rules.';
262: l_proc_name := l_pkg_name||'default_jurisdiction';