DBA Data[Home] [Help]

APPS.PQP_US_PENSION_EXTRACTS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 13: g_gre_tax_unit_id hr_all_organization_units.organization_id%TYPE;

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:
16: TYPE ValTabTyp IS TABLE OF ben_Ext_rslt_dtl.val_01%TYPE
17: INDEX BY Binary_Integer ;

Line 30: ,gre_org_id hr_all_organization_units.organization_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
29: ,payroll_id pay_payrolls_f.payroll_id%TYPE
30: ,gre_org_id hr_all_organization_units.organization_id%TYPE
31: ,con_set_id pay_consolidation_sets.consolidation_set_id%TYPE
32: ,selection_criteria Varchar2(90)
33: ,reporting_dimension Varchar2(90)
34: ,extract_start_date Date