DBA Data[Home] [Help]

APPS.PQP_US_PENSION_EXTRACTS dependencies on BEN_EXT_RSLT

Line 16: TYPE ValTabTyp IS TABLE OF ben_Ext_rslt_dtl.val_01%TYPE

12: g_person_id per_all_assignments_f.person_id%TYPE;
13: g_gre_tax_unit_id hr_all_organization_units.organization_id%TYPE;
14: g_total_dtl_lines Number;
15:
16: TYPE ValTabTyp IS TABLE OF ben_Ext_rslt_dtl.val_01%TYPE
17: INDEX BY Binary_Integer ;
18:
19: TYPE extract_params IS RECORD
20: (session_id Number

Line 25: ,concurrent_req_id ben_ext_rslt.request_id%TYPE

21: ,ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE
22: ,business_group_id per_business_groups.business_group_id%TYPE
23: ,legislation_code per_business_groups.legislation_code%TYPE
24: ,currency_code per_business_groups.currency_code%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

Line 333: (p_business_group_id IN ben_ext_rslt_dtl.business_group_id%TYPE

329: -- =============================================================================
330: -- Del_Service_Detail_Recs:
331: -- =============================================================================
332: FUNCTION Del_Service_Detail_Recs
333: (p_business_group_id IN ben_ext_rslt_dtl.business_group_id%TYPE
334: ) RETURN Number;
335:
336: -- =============================================================================
337: -- Get_Current_Extract_Result: