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_US_PENSION_EXTRACTS dependencies on BEN_EXT_RCD

Line 231: FROM ben_ext_rcd rcd

227: CURSOR csr_ext_rcd_id(c_hide_flag IN VARCHAR2
228: ,c_rcd_type_cd IN VARCHAR2
229: ) IS
230: SELECT rcd.ext_rcd_id
231: FROM ben_ext_rcd rcd
232: ,ben_ext_rcd_in_file rin
233: ,ben_ext_dfn dfn
234: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract executing currently
235: AND rin.ext_file_id = dfn.ext_file_id

Line 232: ,ben_ext_rcd_in_file rin

228: ,c_rcd_type_cd IN VARCHAR2
229: ) IS
230: SELECT rcd.ext_rcd_id
231: FROM ben_ext_rcd rcd
232: ,ben_ext_rcd_in_file rin
233: ,ben_ext_dfn dfn
234: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract executing currently
235: AND rin.ext_file_id = dfn.ext_file_id
236: AND rin.hide_flag = c_hide_flag -- Y=Hidden, N=Not Hidden

Line 1674: (p_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE

1670: -- ================================================================================
1671: -- ~ Update_Record_Values :
1672: -- ================================================================================
1673: PROCEDURE Update_Record_Values
1674: (p_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
1675: ,p_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
1676: ,p_data_element_value IN ben_ext_rslt_dtl.val_01%TYPE
1677: ,p_data_ele_seqnum IN NUMBER
1678: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE

Line 1680: CURSOR csr_seqnum (c_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE

1676: ,p_data_element_value IN ben_ext_rslt_dtl.val_01%TYPE
1677: ,p_data_ele_seqnum IN NUMBER
1678: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
1679: ) IS
1680: CURSOR csr_seqnum (c_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
1681: ,c_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
1682: ) IS
1683: SELECT der.ext_data_elmt_id,
1684: der.seq_num,

Line 2322: ben_ext_rcd xrc,

2318: xel.ext_fld_id,
2319: fld.frmt_mask_typ_cd
2320: FROM ben_ext_where_clause xwc,
2321: ben_ext_data_elmt_in_rcd xer,
2322: ben_ext_rcd xrc,
2323: ben_ext_data_elmt xel,
2324: ben_ext_fld fld
2325: WHERE xwc.ext_rcd_in_file_id = p_ext_rcd_in_file_id
2326: AND xwc.cond_ext_data_elmt_in_rcd_id = xer.ext_data_elmt_in_rcd_id

Line 2337: l_rcd_name ben_ext_rcd.NAME%TYPE ;

2333: l_condition VARCHAR2(1);
2334: l_cnt NUMBER;
2335: l_value_without_quotes VARCHAR2(500);
2336: l_dynamic_condition VARCHAR2(9999);
2337: l_rcd_name ben_ext_rcd.NAME%TYPE ;
2338: --
2339: --
2340: BEGIN
2341: --

Line 2796: ,p_ext_dtl_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE

2792: PROCEDURE Process_Ext_Rslt_Dtl_Rec
2793: (p_assignment_id IN per_all_assignments.assignment_id%TYPE
2794: ,p_organization_id IN per_all_assignments.organization_id%TYPE
2795: ,p_effective_date IN DATE
2796: ,p_ext_dtl_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
2797: ,p_rslt_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
2798: ,p_asgaction_no IN NUMBER
2799: ,p_error_message OUT NOCOPY VARCHAR2) IS
2800:

Line 2843: FROM ben_ext_rcd_in_file rif

2839: ,rif.any_or_all_cd
2840: ,rif.seq_num
2841: ,rif.sprs_cd
2842: ,rif.rqd_flag
2843: FROM ben_ext_rcd_in_file rif
2844: ,ben_ext_dfn dfn
2845: WHERE rif.ext_file_id = dfn.ext_file_id
2846: AND rif.ext_rcd_id = c_rcd_id
2847: AND dfn.ext_dfn_id = c_ext_dfn_id;