DBA Data[Home] [Help]

APPS.PQP_US_PENSION_EXTRACTS dependencies on PER_BUSINESS_GROUPS

Line 5: g_legislation_code per_business_groups.legislation_code%TYPE;

1: Package PQP_US_Pension_Extracts AUTHID CURRENT_USER As
2: /* $Header: pquspext.pkh 120.2 2005/11/28 14:16:21 rpinjala 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_gre_tax_unit_id hr_all_organization_units.organization_id%TYPE;
14: g_total_dtl_lines Number;
15:

Line 22: ,business_group_id per_business_groups.business_group_id%TYPE

18:
19: TYPE extract_params IS RECORD
20: (session_id Number
21: ,ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE
22: ,business_group_id per_business_groups.business_group_id%TYPE
23: ,legislation_code per_business_groups.legislation_code%TYPE
24: ,currency_code per_business_groups.currency_code%TYPE
25: ,concurrent_req_id ben_ext_rslt.request_id%TYPE
26: ,ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE

Line 23: ,legislation_code per_business_groups.legislation_code%TYPE

19: TYPE extract_params IS RECORD
20: (session_id Number
21: ,ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE
22: ,business_group_id per_business_groups.business_group_id%TYPE
23: ,legislation_code per_business_groups.legislation_code%TYPE
24: ,currency_code per_business_groups.currency_code%TYPE
25: ,concurrent_req_id ben_ext_rslt.request_id%TYPE
26: ,ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE
27: ,element_set_id pay_element_sets.element_set_id%TYPE

Line 24: ,currency_code per_business_groups.currency_code%TYPE

20: (session_id Number
21: ,ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE
22: ,business_group_id per_business_groups.business_group_id%TYPE
23: ,legislation_code per_business_groups.legislation_code%TYPE
24: ,currency_code per_business_groups.currency_code%TYPE
25: ,concurrent_req_id ben_ext_rslt.request_id%TYPE
26: ,ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE
27: ,element_set_id pay_element_sets.element_set_id%TYPE
28: ,element_type_id pay_element_types_f.element_type_id%TYPE