eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 51: ,org_id hr_all_organization_units.organization_id%TYPE

47: ,ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE
48: ,element_set_id pay_element_sets.element_set_id%TYPE
49: ,element_type_id pay_element_types_f.element_type_id%TYPE
50: ,payroll_id pay_payrolls_f.payroll_id%TYPE
51: ,org_id hr_all_organization_units.organization_id%TYPE
52: ,gre_org_id hr_all_organization_units.organization_id%TYPE
53: ,con_set_id pay_consolidation_sets.consolidation_set_id%TYPE
54: ,selection_criteria VARCHAR2(90)
55: ,reporting_dimension VARCHAR2(90)

Line 52: ,gre_org_id hr_all_organization_units.organization_id%TYPE

48: ,element_set_id pay_element_sets.element_set_id%TYPE
49: ,element_type_id pay_element_types_f.element_type_id%TYPE
50: ,payroll_id pay_payrolls_f.payroll_id%TYPE
51: ,org_id hr_all_organization_units.organization_id%TYPE
52: ,gre_org_id hr_all_organization_units.organization_id%TYPE
53: ,con_set_id pay_consolidation_sets.consolidation_set_id%TYPE
54: ,selection_criteria VARCHAR2(90)
55: ,reporting_dimension VARCHAR2(90)
56: ,extract_start_date DATE

Line 66: ,gre_org_id hr_all_organization_units.organization_id%TYPE

62:
63: TYPE org_details IS RECORD
64: (business_group_id per_business_groups.business_group_id%TYPE
65: ,legislation_code per_business_groups.legislation_code%TYPE
66: ,gre_org_id hr_all_organization_units.organization_id%TYPE
67: );
68: TYPE t_org_details IS TABLE OF org_details INDEX BY Binary_Integer;
69: g_ord_details t_org_details;
70: g_ord_details1 t_org_details;

Line 152: ,orgname hr_all_organization_units.name%TYPE

148: ,endingdt DATE
149: ,extract_type VARCHAR2(1)
150: ,payrollname pay_payrolls_f.payroll_name%TYPE
151: ,consolset pay_consolidation_sets.consolidation_set_name%TYPE
152: ,orgname hr_all_organization_units.name%TYPE
153: ,orgid hr_all_organization_units.organization_id%TYPE
154: );
155:
156: TYPE t_conc_prog_details IS TABLE OF conc_prog_details INDEX BY Binary_Integer;

Line 153: ,orgid hr_all_organization_units.organization_id%TYPE

149: ,extract_type VARCHAR2(1)
150: ,payrollname pay_payrolls_f.payroll_name%TYPE
151: ,consolset pay_consolidation_sets.consolidation_set_name%TYPE
152: ,orgname hr_all_organization_units.name%TYPE
153: ,orgid hr_all_organization_units.organization_id%TYPE
154: );
155:
156: TYPE t_conc_prog_details IS TABLE OF conc_prog_details INDEX BY Binary_Integer;
157: g_conc_prog_details t_conc_prog_details;

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

157: g_conc_prog_details t_conc_prog_details;
158:
159: --Child organizations
160: TYPE org_list IS RECORD
161: ( org_id hr_all_organization_units.organization_id%TYPE);
162:
163: TYPE t_org_list IS TABLE OF org_list INDEX BY Binary_Integer;
164: g_org_list t_org_list;
165: