APPS.PQP_NL_PENSION_EXTRACTS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 65: ,org_id hr_all_organization_units.organization_id%TYPE

61: ,ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE
62: ,element_set_id pay_element_sets.element_set_id%TYPE
63: ,element_type_id pay_element_types_f.element_type_id%TYPE
64: ,payroll_id pay_payrolls_f.payroll_id%TYPE
65: ,org_id hr_all_organization_units.organization_id%TYPE
66: ,gre_org_id hr_all_organization_units.organization_id%TYPE
67: ,con_set_id pay_consolidation_sets.consolidation_set_id%TYPE
68: ,selection_criteria VARCHAR2(90)
69: ,reporting_dimension VARCHAR2(90)

Line 66: ,gre_org_id hr_all_organization_units.organization_id%TYPE

62: ,element_set_id pay_element_sets.element_set_id%TYPE
63: ,element_type_id pay_element_types_f.element_type_id%TYPE
64: ,payroll_id pay_payrolls_f.payroll_id%TYPE
65: ,org_id hr_all_organization_units.organization_id%TYPE
66: ,gre_org_id hr_all_organization_units.organization_id%TYPE
67: ,con_set_id pay_consolidation_sets.consolidation_set_id%TYPE
68: ,selection_criteria VARCHAR2(90)
69: ,reporting_dimension VARCHAR2(90)
70: ,extract_start_date DATE

Line 81: ,gre_org_id hr_all_organization_units.organization_id%TYPE

77:
78: TYPE org_details IS RECORD
79: (business_group_id per_business_groups.business_group_id%TYPE
80: ,legislation_code per_business_groups.legislation_code%TYPE
81: ,gre_org_id hr_all_organization_units.organization_id%TYPE
82: );
83: TYPE t_org_details IS TABLE OF org_details INDEX BY Binary_Integer;
84: g_ord_details t_org_details;
85: g_ord_details1 t_org_details;

Line 89: (gre_org_id hr_all_organization_units.organization_id%TYPE

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

Line 96: (gre_org_id hr_all_organization_units.organization_id%TYPE

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

Line 190: ,orgname hr_all_organization_units.name%TYPE

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

Line 191: ,orgid hr_all_organization_units.organization_id%TYPE

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

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

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