APPS.PER_PEOPLE_V7_PKG dependencies on PER_ADDRESSES

Line 1055: from per_addresses pa

1051: for update of effective_start_date;
1052: --
1053: cursor address is
1054: select date_from
1055: from per_addresses pa
1056: where person_id = X_person_id
1057: and date_from = X_s_hire_Date
1058: for update of date_from;
1059: --

Line 1086: from per_addresses

1082: l_c1 c1%rowtype;
1083: --
1084: cursor c2 is
1085: select *
1086: from per_addresses
1087: where person_id = X_person_id
1088: and date_from = X_S_hire_date;
1089: --
1090: l_c2 c2%rowtype;

Line 1208: update per_addresses

1204: close c2;
1205: --
1206: begin
1207: --
1208: update per_addresses
1209: set date_from = X_hire_date
1210: where person_id = X_person_id
1211: and date_from = X_S_hire_date;
1212: -- VT 01/29/97 #417906 added exception

Line 1326: from per_addresses pa

1322: for update of date_start;
1323: --
1324: cursor address is
1325: select address_id,date_from
1326: from per_addresses pa
1327: where person_id = X_person_id
1328: and date_from = X_s_hire_Date
1329: and primary_flag = 'Y'
1330: for update of date_from;

Line 1334: from per_addresses pa

1330: for update of date_from;
1331: --
1332: cursor is_valid_addr(lc_addr_id NUMBER,lc_date_from date) is
1333: select date_from
1334: from per_addresses pa
1335: where person_id = X_Person_Id
1336: and address_id <> lc_addr_id
1337: and primary_flag = 'Y'
1338: and lc_date_from between date_from and nvl(date_to,hr_api.g_eot);

Line 1485: update per_addresses

1481: open is_valid_addr(l_dummy_num,X_Hire_Date);
1482: fetch is_valid_addr into l_dummy_date;
1483: if (is_valid_addr%notfound) then
1484: --
1485: update per_addresses
1486: set date_from = X_Hire_Date
1487: where person_id = X_Person_Id
1488: and date_from = X_S_Hire_Date
1489: and address_id = l_dummy_num;