DBA Data[Home] [Help]

APPS.PQP_NL_PENSION_EXTRACTS dependencies on PAY_PAYROLLS_F

Line 64: ,payroll_id pay_payrolls_f.payroll_id%TYPE

60: ,concurrent_req_id ben_ext_rslt.request_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)

Line 122: ,payroll_id pay_payrolls_f.payroll_id%TYPE

118: ,assignment_status per_assignment_status_types.user_status%TYPE
119: ,employment_category hr_lookups.meaning%TYPE
120: ,date_start DATE
121: ,termination_date DATE
122: ,payroll_id pay_payrolls_f.payroll_id%TYPE
123: ,abp_er_num VARCHAR2(10)
124: ,ee_num per_all_people_f.employee_number%TYPE
125: ,asg_seq_num per_all_assignments_f.assignment_sequence%TYPE
126: ,ni_num per_all_people_f.national_identifier%TYPE

Line 188: ,payrollname pay_payrolls_f.payroll_name%TYPE

184: ,elementname pay_element_types_f.element_name%TYPE
185: ,beginningdt DATE
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: );