APPS.HR_PROCESS_ADDRESS_SS dependencies on PER_ADDRESSES

Line 1022: l_old_address_id per_addresses.address_id%TYPE;

1018: IS
1019:
1020: l_proc varchar2(200) := g_package || 'update_person_address';
1021: l_old_ovn number;
1022: l_old_address_id per_addresses.address_id%TYPE;
1023: --startregistration anupam
1024: l_primary_flag per_addresses.primary_flag%TYPE;
1025: --endregistration anupam
1026: l_review_item_name varchar2(50);

Line 1024: l_primary_flag per_addresses.primary_flag%TYPE;

1020: l_proc varchar2(200) := g_package || 'update_person_address';
1021: l_old_ovn number;
1022: l_old_address_id per_addresses.address_id%TYPE;
1023: --startregistration anupam
1024: l_primary_flag per_addresses.primary_flag%TYPE;
1025: --endregistration anupam
1026: l_review_item_name varchar2(50);
1027: l_date_to date;
1028: l_date_from date;

Line 2457: l_old_address_id per_addresses.address_id%TYPE;

2453:
2454: l_proc varchar2(200) := g_package || 'process_api';
2455: l_user_date_format varchar2(200);
2456: l_validate BOOLEAN := true; l_old_ovn NUMBER; l_ovn NUMBER;
2457: l_old_address_id per_addresses.address_id%TYPE;
2458: l_action VARCHAR2(100); l_effective_date date;
2459: l_address per_addresses%ROWTYPE;
2460: l_pradd_ovrlap BOOLEAN := FALSE;
2461: l_contact_or_person varchar2(100);

Line 2459: l_address per_addresses%ROWTYPE;

2455: l_user_date_format varchar2(200);
2456: l_validate BOOLEAN := true; l_old_ovn NUMBER; l_ovn NUMBER;
2457: l_old_address_id per_addresses.address_id%TYPE;
2458: l_action VARCHAR2(100); l_effective_date date;
2459: l_address per_addresses%ROWTYPE;
2460: l_pradd_ovrlap BOOLEAN := FALSE;
2461: l_contact_or_person varchar2(100);
2462: l_check_for_sfl varchar2(10);
2463: l_sfl_g_contact_step_id NUMBER;