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 AS
2: /* $Header: pqpnlpext.pkh 120.8.12010000.2 2008/08/05 14:21:10 ubhat ship $ */
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 55: ,business_group_id per_business_groups.business_group_id%TYPE

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

Line 56: ,legislation_code per_business_groups.legislation_code%TYPE

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

Line 57: ,currency_code per_business_groups.currency_code%TYPE

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

Line 77: (business_group_id per_business_groups.business_group_id%TYPE

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

Line 78: ,legislation_code per_business_groups.legislation_code%TYPE

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