DBA Data[Home] [Help]

APPS.PQP_US_PENSION_EXTRACTS dependencies on PAY_PAYROLLS_F

Line 29: ,payroll_id pay_payrolls_f.payroll_id%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
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)

Line 85: ,payroll_id pay_payrolls_f.payroll_id%TYPE

81: ,employment_category hr_lookups.meaning%TYPE
82: ,normal_hours per_all_assignments_f.normal_hours%TYPE
83: ,date_start Date
84: ,termination_date Date
85: ,payroll_id pay_payrolls_f.payroll_id%TYPE
86: ,PPG_Billing_Code Varchar2(150)
87: ,Payment_Mode Varchar2(150)
88: );
89: TYPE t_assig_details IS TABLE OF assig_details INDEX BY Binary_Integer;

Line 142: ,payrollname PAY_PAYROLLS_F.PAYROLL_NAME%TYPE

138: ,elementname pay_element_types_f.element_name%TYPE
139: ,beginningdt Date
140: ,endingdt Date
141: ,grename hr_organization_units.NAME%TYPE
142: ,payrollname PAY_PAYROLLS_F.PAYROLL_NAME%TYPE
143: ,consolset PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_NAME%TYPE
144: );
145: TYPE t_conc_prog_details IS TABLE OF conc_prog_details INDEX BY Binary_Integer;
146: g_conc_prog_details t_conc_prog_details;