APPS.PAY_PAYSGSOE_XMLP_PKG dependencies on HR_LOCATIONS

Line 44: v_address_line_1 hr_locations.address_line_1%type;

40: end;
41:
42: function cf_address_line1formula(expense_check_send_to_address in varchar2, person_id in number, location_id in number) return char is
43:
44: v_address_line_1 hr_locations.address_line_1%type;
45: v_address_line_2 hr_locations.address_line_2%type;
46: v_address_line_3 hr_locations.address_line_3%type;
47: v_town_city hr_locations.town_or_city%type;
48: v_postal_code hr_locations.postal_code%type;

Line 45: v_address_line_2 hr_locations.address_line_2%type;

41:
42: function cf_address_line1formula(expense_check_send_to_address in varchar2, person_id in number, location_id in number) return char is
43:
44: v_address_line_1 hr_locations.address_line_1%type;
45: v_address_line_2 hr_locations.address_line_2%type;
46: v_address_line_3 hr_locations.address_line_3%type;
47: v_town_city hr_locations.town_or_city%type;
48: v_postal_code hr_locations.postal_code%type;
49: v_country fnd_territories_tl.territory_short_name%type;

Line 46: v_address_line_3 hr_locations.address_line_3%type;

42: function cf_address_line1formula(expense_check_send_to_address in varchar2, person_id in number, location_id in number) return char is
43:
44: v_address_line_1 hr_locations.address_line_1%type;
45: v_address_line_2 hr_locations.address_line_2%type;
46: v_address_line_3 hr_locations.address_line_3%type;
47: v_town_city hr_locations.town_or_city%type;
48: v_postal_code hr_locations.postal_code%type;
49: v_country fnd_territories_tl.territory_short_name%type;
50: begin

Line 47: v_town_city hr_locations.town_or_city%type;

43:
44: v_address_line_1 hr_locations.address_line_1%type;
45: v_address_line_2 hr_locations.address_line_2%type;
46: v_address_line_3 hr_locations.address_line_3%type;
47: v_town_city hr_locations.town_or_city%type;
48: v_postal_code hr_locations.postal_code%type;
49: v_country fnd_territories_tl.territory_short_name%type;
50: begin
51: if expense_check_send_to_address = 'H' then

Line 48: v_postal_code hr_locations.postal_code%type;

44: v_address_line_1 hr_locations.address_line_1%type;
45: v_address_line_2 hr_locations.address_line_2%type;
46: v_address_line_3 hr_locations.address_line_3%type;
47: v_town_city hr_locations.town_or_city%type;
48: v_postal_code hr_locations.postal_code%type;
49: v_country fnd_territories_tl.territory_short_name%type;
50: begin
51: if expense_check_send_to_address = 'H' then
52: pay_sg_soe.get_home_address(person_id,