DBA Data[Home] [Help]

APPS.GHR_US_NFC_EXTRACTS dependencies on PER_BUSINESS_GROUPS

Line 9: g_legislation_code per_business_groups.legislation_code%type;

5: -- Package global variables
6: -- =============================================================================
7:
8: g_conc_request_id number;
9: g_legislation_code per_business_groups.legislation_code%type;
10: g_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%type;
11: g_business_group_id per_business_groups.business_group_id%type;
12: g_person_id per_all_assignments_f.person_id%type;
13: g_effective_date date;

Line 11: g_business_group_id per_business_groups.business_group_id%type;

7:
8: g_conc_request_id number;
9: g_legislation_code per_business_groups.legislation_code%type;
10: g_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%type;
11: g_business_group_id per_business_groups.business_group_id%type;
12: g_person_id per_all_assignments_f.person_id%type;
13: g_effective_date date;
14: g_ext_start_dt date;
15: g_ext_end_dt date;

Line 31: ,business_group_id per_business_groups.business_group_id%TYPE

27:
28:
29: TYPE extract_params IS RECORD
30: (session_id number
31: ,business_group_id per_business_groups.business_group_id%TYPE
32: ,concurrent_req_id ben_ext_rslt.request_id%TYPE
33: ,ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE
34: ,transmission_type varchar2(30)
35: ,date_criteria varchar2(30)

Line 109: ,business_group_id per_business_groups.business_group_id%TYPE

105: index by binary_integer ;
106:
107: TYPE pa_extract_params IS RECORD
108: (session_id number
109: ,business_group_id per_business_groups.business_group_id%TYPE
110: ,concurrent_req_id ben_ext_rslt.request_id%TYPE
111: ,ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE
112: ,transmission_type varchar2(30)
113: ,date_criteria varchar2(30)