APPS.PAY_DK_ARCHIVE_EHOL dependencies on PER_ADDRESSES

Line 1121: FROM per_addresses pad

1117: ,pad.REGION_1
1118: ,pad.REGION_2
1119: ,pad.REGION_3
1120: ,pad.style
1121: FROM per_addresses pad
1122: , per_all_people_f pap
1123: WHERE pad.person_id = pap.person_id
1124: AND pad.primary_flag = 'Y'
1125: AND pap.person_id = p_person_id

Line 1174: FROM per_addresses_v

1170:
1171: /* Get the territory */
1172: CURSOR csr_get_territory(pid per_all_people_f.person_id%type) IS
1173: SELECT *
1174: FROM per_addresses_v
1175: WHERE person_id =pid
1176: and primary_flag='Y';
1177:
1178: rg_csr_get_territory csr_get_territory%rowtype;