DBA Data[Home] [Help]

APPS.GHR_US_NFC_EXTRACTS dependencies on GHR_PA_REQUESTS

Line 59: ,first_noa_code ghr_pa_requests.first_noa_code%type

55: ,effective_date date
56: ,last_update_date date
57: ,pa_request_id number
58: ,pa_notification_id number
59: ,first_noa_code ghr_pa_requests.first_noa_code%type
60: ,second_noa_code ghr_pa_requests.second_noa_code%type
61: ,ext_start_date date
62: ,extract_end_dt date
63: ,remark_code number(15)

Line 60: ,second_noa_code ghr_pa_requests.second_noa_code%type

56: ,last_update_date date
57: ,pa_request_id number
58: ,pa_notification_id number
59: ,first_noa_code ghr_pa_requests.first_noa_code%type
60: ,second_noa_code ghr_pa_requests.second_noa_code%type
61: ,ext_start_date date
62: ,extract_end_dt date
63: ,remark_code number(15)
64: ,pa_remark_id number(15)

Line 79: type t_pa_req_rec is table of ghr_pa_requests%ROWTYPE

75: ,person_id number(15)
76: ,assignment_id number(15)
77: ,address_id number(15)
78: );
79: type t_pa_req_rec is table of ghr_pa_requests%ROWTYPE
80: index by binary_integer;
81: g_rpa_rec t_pa_req_rec;
82: g_awd_rec t_pa_req_rec;
83: --