APPS.HR_PROCESS_ADDRESS_SS dependencies on PER_ADDRESSES

Line 1014: l_old_address_id per_addresses.address_id%TYPE;

1010: IS
1011:
1012: l_proc varchar2(200) := g_package || 'update_person_address';
1013: l_old_ovn number;
1014: l_old_address_id per_addresses.address_id%TYPE;
1015: --startregistration anupam
1016: l_primary_flag per_addresses.primary_flag%TYPE;
1017: --endregistration anupam
1018: l_review_item_name varchar2(50);

Line 1016: l_primary_flag per_addresses.primary_flag%TYPE;

1012: l_proc varchar2(200) := g_package || 'update_person_address';
1013: l_old_ovn number;
1014: l_old_address_id per_addresses.address_id%TYPE;
1015: --startregistration anupam
1016: l_primary_flag per_addresses.primary_flag%TYPE;
1017: --endregistration anupam
1018: l_review_item_name varchar2(50);
1019: l_date_to date;
1020: l_date_from date;

Line 2449: l_old_address_id per_addresses.address_id%TYPE;

2445:
2446: l_proc varchar2(200) := g_package || 'process_api';
2447: l_user_date_format varchar2(200);
2448: l_validate BOOLEAN := true; l_old_ovn NUMBER; l_ovn NUMBER;
2449: l_old_address_id per_addresses.address_id%TYPE;
2450: l_action VARCHAR2(100); l_effective_date date;
2451: l_address per_addresses%ROWTYPE;
2452: l_pradd_ovrlap BOOLEAN := FALSE;
2453: l_contact_or_person varchar2(100);

Line 2451: l_address per_addresses%ROWTYPE;

2447: l_user_date_format varchar2(200);
2448: l_validate BOOLEAN := true; l_old_ovn NUMBER; l_ovn NUMBER;
2449: l_old_address_id per_addresses.address_id%TYPE;
2450: l_action VARCHAR2(100); l_effective_date date;
2451: l_address per_addresses%ROWTYPE;
2452: l_pradd_ovrlap BOOLEAN := FALSE;
2453: l_contact_or_person varchar2(100);
2454: l_check_for_sfl varchar2(10);
2455: l_sfl_g_contact_step_id NUMBER;