APPS.PER_TAX_ADDRESS_PKG dependencies on PER_ADDRESSES_V

Line 24: FROM per_addresses_v

20: -- Get overide date and last input date.
21: ----------------------------------------
22: l_date := TO_DATE('01/01/' || (TO_CHAR(p_date_from, 'YYYY')),'DD/MM/YYYY');
23: SELECT MAX(date_from) INTO l_last_date
24: FROM per_addresses_v
25: WHERE person_id = p_person_id AND
26: primary_flag = 'Y' AND
27: date_from <= p_date_from;
28: --l_last_date := to_date('01-APR-2006','DD-MON-YYYY');

Line 44: FROM per_addresses_v

40: NVL(add_information19,''),
41: NVL(add_information17,''),
42: NVL(add_information20,'')
43: INTO l_city, l_county, l_state, l_zip
44: FROM per_addresses_v
45: WHERE person_id = p_person_id AND
46: primary_flag = 'Y' AND
47: date_from = (SELECT max(date_from)
48: FROM per_addresses_v

Line 48: FROM per_addresses_v

44: FROM per_addresses_v
45: WHERE person_id = p_person_id AND
46: primary_flag = 'Y' AND
47: date_from = (SELECT max(date_from)
48: FROM per_addresses_v
49: WHERE date_from BETWEEN l_date AND p_date_from AND
50: person_id = p_person_id AND
51: primary_flag = 'Y');
52: hr_utility.set_location(' l_city -> '|| l_city, 60);

Line 63: FROM per_addresses_v

59: region_1,
60: region_2,
61: postal_code
62: INTO l_city, l_county, l_state, l_zip
63: FROM per_addresses_v
64: WHERE person_id = p_person_id AND
65: primary_flag = 'Y' AND
66: l_date BETWEEN date_from AND
67: NVL(date_to, TO_DATE('31/12/4712', 'DD/MM/YYYY'));

Line 103: SELECT 'N' FROM per_addresses_v

99: l_chk_date VARCHAR2(30);
100: l_date DATE;
101: l_state VARCHAR2(30);
102: CURSOR c_new_entry IS
103: SELECT 'N' FROM per_addresses_v
104: WHERE person_id = p_person_id AND
105: date_from IS NOT NULL;
106:
107: CURSOR c_state(p_person_id IN NUMBER,p_date IN DATE) IS

Line 109: FROM per_addresses_v

105: date_from IS NOT NULL;
106:
107: CURSOR c_state(p_person_id IN NUMBER,p_date IN DATE) IS
108: SELECT region_2
109: FROM per_addresses_v
110: WHERE person_id = p_person_id
111: AND primary_flag = 'Y'
112: AND p_date BETWEEN date_from
113: AND NVL(date_to, TO_DATE('31/12/4712', 'DD/MM/YYYY'));

Line 140: FROM per_addresses_v

136: IF c_state%NOTFOUND THEN
137:
138: SELECT region_2
139: INTO l_state
140: FROM per_addresses_v
141: WHERE person_id = p_person_id AND
142: primary_flag = 'Y' AND
143: date_from = (SELECT max(date_from)
144: FROM per_addresses_v

Line 144: FROM per_addresses_v

140: FROM per_addresses_v
141: WHERE person_id = p_person_id AND
142: primary_flag = 'Y' AND
143: date_from = (SELECT max(date_from)
144: FROM per_addresses_v
145: WHERE date_from >= l_date
146: AND date_from < p_date_from AND
147: person_id = p_person_id AND
148: primary_flag = 'Y');