APPS.PQP_NL_PENSION_EXTRACTS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 63: ,org_id hr_all_organization_units.organization_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
62: ,payroll_id pay_payrolls_f.payroll_id%TYPE
63: ,org_id hr_all_organization_units.organization_id%TYPE
64: ,gre_org_id hr_all_organization_units.organization_id%TYPE
65: ,con_set_id pay_consolidation_sets.consolidation_set_id%TYPE
66: ,selection_criteria VARCHAR2(90)
67: ,reporting_dimension VARCHAR2(90)

Line 64: ,gre_org_id hr_all_organization_units.organization_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
62: ,payroll_id pay_payrolls_f.payroll_id%TYPE
63: ,org_id hr_all_organization_units.organization_id%TYPE
64: ,gre_org_id hr_all_organization_units.organization_id%TYPE
65: ,con_set_id pay_consolidation_sets.consolidation_set_id%TYPE
66: ,selection_criteria VARCHAR2(90)
67: ,reporting_dimension VARCHAR2(90)
68: ,extract_start_date DATE

Line 79: ,gre_org_id hr_all_organization_units.organization_id%TYPE

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;
83: g_ord_details1 t_org_details;

Line 87: (gre_org_id hr_all_organization_units.organization_id%TYPE

83: g_ord_details1 t_org_details;
84:
85: --Table contains all the employers
86: TYPE employer_list IS RECORD
87: (gre_org_id hr_all_organization_units.organization_id%TYPE
88: );
89: TYPE t_employer_list IS TABLE OF employer_list INDEX BY Binary_Integer;
90: g_employer_list t_employer_list;
91:

Line 94: (gre_org_id hr_all_organization_units.organization_id%TYPE

90: g_employer_list t_employer_list;
91:
92: -- Table contains subgroups of organizations which has to be totalled
93: TYPE employer_child_list IS RECORD
94: (gre_org_id hr_all_organization_units.organization_id%TYPE
95: );
96: TYPE t_employer_child_list IS TABLE OF employer_child_list INDEX BY Binary_Integer;
97: g_employer_child_list t_employer_child_list;
98:

Line 188: ,orgname hr_all_organization_units.name%TYPE

184: ,endingdt DATE
185: ,grename hr_organization_units.name%TYPE
186: ,payrollname pay_payrolls_f.payroll_name%TYPE
187: ,consolset pay_consolidation_sets.consolidation_set_name%TYPE
188: ,orgname hr_all_organization_units.name%TYPE
189: ,orgid hr_all_organization_units.organization_id%TYPE
190: );
191:
192: TYPE t_conc_prog_details IS TABLE OF conc_prog_details INDEX BY Binary_Integer;

Line 189: ,orgid hr_all_organization_units.organization_id%TYPE

185: ,grename hr_organization_units.name%TYPE
186: ,payrollname pay_payrolls_f.payroll_name%TYPE
187: ,consolset pay_consolidation_sets.consolidation_set_name%TYPE
188: ,orgname hr_all_organization_units.name%TYPE
189: ,orgid hr_all_organization_units.organization_id%TYPE
190: );
191:
192: TYPE t_conc_prog_details IS TABLE OF conc_prog_details INDEX BY Binary_Integer;
193: g_conc_prog_details t_conc_prog_details;

Line 247: ( org_id hr_all_organization_units.organization_id%TYPE);

243:
244: g_si_rec t_si_date_rows;
245:
246: TYPE org_list IS RECORD
247: ( org_id hr_all_organization_units.organization_id%TYPE);
248:
249: TYPE t_org_list IS TABLE OF org_list INDEX BY Binary_Integer;
250: g_org_list t_org_list;
251: