APPS.PQP_NL_PENSION_EXTRACTS dependencies on PER_BUSINESS_GROUPS

Line 5: g_legislation_code per_business_groups.legislation_code%TYPE;

1: PACKAGE PQP_NL_PENSION_EXTRACTS AUTHID CURRENT_USER AS
2: /* $Header: pqpnlpext.pkh 120.12 2010/09/29 10:36:49 rsahai noship $ */
3:
4: g_conc_request_id NUMBER;
5: g_legislation_code per_business_groups.legislation_code%TYPE;
6: g_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
7: g_action_effective_date DATE;
8: g_action_type VARCHAR2(50);
9: g_asgrun_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

Line 11: g_business_group_id per_business_groups.business_group_id%TYPE;

7: g_action_effective_date DATE;
8: g_action_type VARCHAR2(50);
9: g_asgrun_dim_id pay_balance_dimensions.balance_dimension_id%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_index_fur NUMBER := 0;
14: g_count_fur NUMBER := 0;
15: g_index_ipap NUMBER := 0;

Line 57: ,business_group_id per_business_groups.business_group_id%TYPE

53:
54: TYPE extract_params IS RECORD
55: (session_id NUMBER
56: ,ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE
57: ,business_group_id per_business_groups.business_group_id%TYPE
58: ,legislation_code per_business_groups.legislation_code%TYPE
59: ,currency_code per_business_groups.currency_code%TYPE
60: ,concurrent_req_id ben_ext_rslt.request_id%TYPE
61: ,ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE

Line 58: ,legislation_code per_business_groups.legislation_code%TYPE

54: TYPE extract_params IS RECORD
55: (session_id NUMBER
56: ,ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE
57: ,business_group_id per_business_groups.business_group_id%TYPE
58: ,legislation_code per_business_groups.legislation_code%TYPE
59: ,currency_code per_business_groups.currency_code%TYPE
60: ,concurrent_req_id ben_ext_rslt.request_id%TYPE
61: ,ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE
62: ,element_set_id pay_element_sets.element_set_id%TYPE

Line 59: ,currency_code per_business_groups.currency_code%TYPE

55: (session_id NUMBER
56: ,ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE
57: ,business_group_id per_business_groups.business_group_id%TYPE
58: ,legislation_code per_business_groups.legislation_code%TYPE
59: ,currency_code per_business_groups.currency_code%TYPE
60: ,concurrent_req_id ben_ext_rslt.request_id%TYPE
61: ,ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE
62: ,element_set_id pay_element_sets.element_set_id%TYPE
63: ,element_type_id pay_element_types_f.element_type_id%TYPE

Line 79: (business_group_id per_business_groups.business_group_id%TYPE

75: TYPE t_extract_params IS TABLE OF extract_params INDEX BY Binary_Integer;
76: g_extract_params t_extract_params;
77:
78: TYPE org_details IS RECORD
79: (business_group_id per_business_groups.business_group_id%TYPE
80: ,legislation_code per_business_groups.legislation_code%TYPE
81: ,gre_org_id hr_all_organization_units.organization_id%TYPE
82: );
83: TYPE t_org_details IS TABLE OF org_details INDEX BY Binary_Integer;

Line 80: ,legislation_code per_business_groups.legislation_code%TYPE

76: g_extract_params t_extract_params;
77:
78: TYPE org_details IS RECORD
79: (business_group_id per_business_groups.business_group_id%TYPE
80: ,legislation_code per_business_groups.legislation_code%TYPE
81: ,gre_org_id hr_all_organization_units.organization_id%TYPE
82: );
83: TYPE t_org_details IS TABLE OF org_details INDEX BY Binary_Integer;
84: g_ord_details t_org_details;