DBA Data[Home] [Help]

APPS.PQP_US_SRS_EXTRACTS dependencies on BEN_EXT_RSLT_DTL

Line 326: (p_business_group_id ben_ext_rslt_dtl.business_group_id%TYPE

322: ,p_extract_end_date In date
323: ) Return Varchar2 ;
324:
325: Function Del_Service_Detail_Recs
326: (p_business_group_id ben_ext_rslt_dtl.business_group_id%TYPE
327: )Return Number;
328:
329: ---Added new function to get EE DCP contribution Limit
330: Function get_dcp_limit

Line 341: ,p_data_element_value In ben_ext_rslt_dtl.val_01%TYPE

337: -- ============================
338: Procedure Update_Record_Values
339: (p_ext_rcd_id In ben_ext_rcd.ext_rcd_id%TYPE
340: ,p_ext_data_element_name In ben_ext_data_elmt.name%TYPE
341: ,p_data_element_value In ben_ext_rslt_dtl.val_01%TYPE
342: ,p_data_ele_seqnum In Number Default Null
343: ,p_ext_dtl_rec In out nocopy ben_ext_rslt_dtl%ROWTYPE
344: );
345:

Line 343: ,p_ext_dtl_rec In out nocopy ben_ext_rslt_dtl%ROWTYPE

339: (p_ext_rcd_id In ben_ext_rcd.ext_rcd_id%TYPE
340: ,p_ext_data_element_name In ben_ext_data_elmt.name%TYPE
341: ,p_data_element_value In ben_ext_rslt_dtl.val_01%TYPE
342: ,p_data_ele_seqnum In Number Default Null
343: ,p_ext_dtl_rec In out nocopy ben_ext_rslt_dtl%ROWTYPE
344: );
345:
346: Function Get_PTD_Start_End_Date
347: (p_assignment_id In per_all_assignments_f.assignment_id%TYPE

Line 352: (p_dtl_rec In out nocopy ben_ext_rslt_dtl%ROWTYPE );

348: ,p_effective_date In Date
349: ) Return Varchar2;
350:
351: Procedure Ins_Rslt_Dtl
352: (p_dtl_rec In out nocopy ben_ext_rslt_dtl%ROWTYPE );
353:
354:
355: End PQP_US_SRS_Extracts;