APPS.PQP_PENSION_EXTRACTS dependencies on PER_BUSINESS_GROUPS

Line 6: g_legislation_code per_business_groups.legislation_code%TYPE;

2: /* $Header: pqglpext.pkh 120.1 2005/10/04 12:01:24 rpinjala noship $ */
3:
4:
5: g_conc_request_id number;
6: g_legislation_code per_business_groups.legislation_code%TYPE;
7: g_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
8: g_action_effective_date date;
9: g_action_type varchar2(50);
10: g_asgrun_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

Line 12: g_business_group_id per_business_groups.business_group_id%TYPE;

8: g_action_effective_date date;
9: g_action_type varchar2(50);
10: g_asgrun_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
11: g_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
12: g_business_group_id per_business_groups.business_group_id%TYPE;
13: g_person_id per_all_assignments_f.person_id%TYPE;
14: g_total_dtl_lines number(5);
15: g_processing_addl_asgs boolean;
16: g_gre_org_id number(15);

Line 25: ,business_group_id per_business_groups.business_group_id%TYPE

21: -- This is used to store the conc parameters
22: TYPE extract_params IS RECORD
23: (session_id number
24: ,ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE
25: ,business_group_id per_business_groups.business_group_id%TYPE
26: ,legislation_code per_business_groups.legislation_code%TYPE
27: ,currency_code per_business_groups.currency_code%TYPE
28: ,concurrent_req_id ben_ext_rslt.request_id%TYPE
29: ,ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE

Line 26: ,legislation_code per_business_groups.legislation_code%TYPE

22: TYPE extract_params IS RECORD
23: (session_id number
24: ,ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE
25: ,business_group_id per_business_groups.business_group_id%TYPE
26: ,legislation_code per_business_groups.legislation_code%TYPE
27: ,currency_code per_business_groups.currency_code%TYPE
28: ,concurrent_req_id ben_ext_rslt.request_id%TYPE
29: ,ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE
30: ,element_set_id pay_element_sets.element_set_id%TYPE

Line 27: ,currency_code per_business_groups.currency_code%TYPE

23: (session_id number
24: ,ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE
25: ,business_group_id per_business_groups.business_group_id%TYPE
26: ,legislation_code per_business_groups.legislation_code%TYPE
27: ,currency_code per_business_groups.currency_code%TYPE
28: ,concurrent_req_id ben_ext_rslt.request_id%TYPE
29: ,ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE
30: ,element_set_id pay_element_sets.element_set_id%TYPE
31: ,element_type_id pay_element_types_f.element_type_id%TYPE