APPS.IGS_GE_PRC_TRANSFER dependencies on IGS_PE_STATISTICS

Line 38: v_location_country IGS_PE_STATISTICS.term_location_country%TYPE;

34: p_person_id IN NUMBER ,
35: p_start_dt IN DATE ,
36: p_location_type IN VARCHAR2 )
37: RETURN VARCHAR2 AS
38: v_location_country IGS_PE_STATISTICS.term_location_country%TYPE;
39: v_location_postcode IGS_PE_STATISTICS.term_location_postcode%TYPE;
40: CURSOR c_get_term_location_data IS
41: SELECT term_location_country, term_location_postcode
42: FROM IGS_PE_STATISTICS

Line 39: v_location_postcode IGS_PE_STATISTICS.term_location_postcode%TYPE;

35: p_start_dt IN DATE ,
36: p_location_type IN VARCHAR2 )
37: RETURN VARCHAR2 AS
38: v_location_country IGS_PE_STATISTICS.term_location_country%TYPE;
39: v_location_postcode IGS_PE_STATISTICS.term_location_postcode%TYPE;
40: CURSOR c_get_term_location_data IS
41: SELECT term_location_country, term_location_postcode
42: FROM IGS_PE_STATISTICS
43: WHERE person_id = p_person_id AND

Line 42: FROM IGS_PE_STATISTICS

38: v_location_country IGS_PE_STATISTICS.term_location_country%TYPE;
39: v_location_postcode IGS_PE_STATISTICS.term_location_postcode%TYPE;
40: CURSOR c_get_term_location_data IS
41: SELECT term_location_country, term_location_postcode
42: FROM IGS_PE_STATISTICS
43: WHERE person_id = p_person_id AND
44: start_dt = p_start_dt;
45: CURSOR c_get_home_location_data IS
46: SELECT home_location_country, home_location_postcode

Line 47: FROM IGS_PE_STATISTICS

43: WHERE person_id = p_person_id AND
44: start_dt = p_start_dt;
45: CURSOR c_get_home_location_data IS
46: SELECT home_location_country, home_location_postcode
47: FROM IGS_PE_STATISTICS
48: WHERE person_id = p_person_id AND
49: start_dt = p_start_dt;
50: BEGIN
51: IF p_location_type = cst_term_location_type THEN