APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on PER_BUSINESS_GROUPS

Line 12: g_legislation_code per_business_groups.legislation_code%TYPE;

8: g_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
9: g_person_id per_all_assignments_f.person_id%TYPE;
10: g_retro_ptp_count NUMBER := 0;
11: g_debug BOOLEAN := FALSE;
12: g_legislation_code per_business_groups.legislation_code%TYPE;
13: g_business_group_id per_business_groups.business_group_id%TYPE;
14: g_ptp_index NUMBER:=0;
15: g_ptp_chg_date DATE;
16: g_ptp_chg_screen_value VARCHAR2(50);

Line 13: g_business_group_id per_business_groups.business_group_id%TYPE;

9: g_person_id per_all_assignments_f.person_id%TYPE;
10: g_retro_ptp_count NUMBER := 0;
11: g_debug BOOLEAN := FALSE;
12: g_legislation_code per_business_groups.legislation_code%TYPE;
13: g_business_group_id per_business_groups.business_group_id%TYPE;
14: g_ptp_index NUMBER:=0;
15: g_ptp_chg_date DATE;
16: g_ptp_chg_screen_value VARCHAR2(50);
17:

Line 43: ,business_group_id per_business_groups.business_group_id%TYPE

39:
40: TYPE extract_params IS RECORD
41: (session_id NUMBER
42: ,ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE
43: ,business_group_id per_business_groups.business_group_id%TYPE
44: ,legislation_code per_business_groups.legislation_code%TYPE
45: ,currency_code per_business_groups.currency_code%TYPE
46: ,concurrent_req_id ben_ext_rslt.request_id%TYPE
47: ,ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE

Line 44: ,legislation_code per_business_groups.legislation_code%TYPE

40: TYPE extract_params IS RECORD
41: (session_id NUMBER
42: ,ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE
43: ,business_group_id per_business_groups.business_group_id%TYPE
44: ,legislation_code per_business_groups.legislation_code%TYPE
45: ,currency_code per_business_groups.currency_code%TYPE
46: ,concurrent_req_id ben_ext_rslt.request_id%TYPE
47: ,ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE
48: ,element_set_id pay_element_sets.element_set_id%TYPE

Line 45: ,currency_code per_business_groups.currency_code%TYPE

41: (session_id NUMBER
42: ,ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE
43: ,business_group_id per_business_groups.business_group_id%TYPE
44: ,legislation_code per_business_groups.legislation_code%TYPE
45: ,currency_code per_business_groups.currency_code%TYPE
46: ,concurrent_req_id ben_ext_rslt.request_id%TYPE
47: ,ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE
48: ,element_set_id pay_element_sets.element_set_id%TYPE
49: ,element_type_id pay_element_types_f.element_type_id%TYPE

Line 64: (business_group_id per_business_groups.business_group_id%TYPE

60: TYPE t_extract_params IS TABLE OF extract_params INDEX BY Binary_Integer;
61: g_extract_params t_extract_params;
62:
63: TYPE org_details IS RECORD
64: (business_group_id per_business_groups.business_group_id%TYPE
65: ,legislation_code per_business_groups.legislation_code%TYPE
66: ,gre_org_id hr_all_organization_units.organization_id%TYPE
67: );
68: TYPE t_org_details IS TABLE OF org_details INDEX BY Binary_Integer;

Line 65: ,legislation_code per_business_groups.legislation_code%TYPE

61: g_extract_params t_extract_params;
62:
63: TYPE org_details IS RECORD
64: (business_group_id per_business_groups.business_group_id%TYPE
65: ,legislation_code per_business_groups.legislation_code%TYPE
66: ,gre_org_id hr_all_organization_units.organization_id%TYPE
67: );
68: TYPE t_org_details IS TABLE OF org_details INDEX BY Binary_Integer;
69: g_ord_details t_org_details;