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

Line 36: FROM ben_ext_rcd rcd

32: rin.seq_num,
33: rin.hide_flag,
34: rcd.ext_rcd_id,
35: rcd.rcd_type_cd
36: FROM ben_ext_rcd rcd
37: ,ben_ext_rcd_in_file rin
38: ,ben_ext_dfn dfn
39: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
40: AND rin.ext_file_id = dfn.ext_file_id

Line 37: ,ben_ext_rcd_in_file rin

33: rin.hide_flag,
34: rcd.ext_rcd_id,
35: rcd.rcd_type_cd
36: FROM ben_ext_rcd rcd
37: ,ben_ext_rcd_in_file rin
38: ,ben_ext_dfn dfn
39: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
40: AND rin.ext_file_id = dfn.ext_file_id
41: AND rin.ext_rcd_id = rcd.ext_rcd_id

Line 49: FROM ben_ext_rcd rcd

45: -- Cursor to get the extract record id's for record sequence number
46: -- =============================================================================
47: CURSOR c_get_rcd_id(c_seq IN Number) IS
48: SELECT rcd.ext_rcd_id
49: FROM ben_ext_rcd rcd
50: ,ben_ext_rcd_in_file rin
51: ,ben_ext_dfn dfn
52: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract executing currently
53: AND rin.ext_file_id = dfn.ext_file_id

Line 50: ,ben_ext_rcd_in_file rin

46: -- =============================================================================
47: CURSOR c_get_rcd_id(c_seq IN Number) IS
48: SELECT rcd.ext_rcd_id
49: FROM ben_ext_rcd rcd
50: ,ben_ext_rcd_in_file rin
51: ,ben_ext_dfn dfn
52: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract executing currently
53: AND rin.ext_file_id = dfn.ext_file_id
54: AND rin.ext_rcd_id = rcd.ext_rcd_id

Line 255: FROM ben_ext_rcd rcd

251: CURSOR csr_ext_rcd_id(c_hide_flag IN Varchar2
252: ,c_rcd_type_cd IN Varchar2
253: ) IS
254: SELECT rcd.ext_rcd_id
255: FROM ben_ext_rcd rcd
256: ,ben_ext_rcd_in_file rin
257: ,ben_ext_dfn dfn
258: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract
259: AND rin.ext_file_id = dfn.ext_file_id

Line 256: ,ben_ext_rcd_in_file rin

252: ,c_rcd_type_cd IN Varchar2
253: ) IS
254: SELECT rcd.ext_rcd_id
255: FROM ben_ext_rcd rcd
256: ,ben_ext_rcd_in_file rin
257: ,ben_ext_dfn dfn
258: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract
259: AND rin.ext_file_id = dfn.ext_file_id
260: AND rin.hide_flag = c_hide_flag -- Y=Hidden, N=Not Hidden

Line 269: FROM ben_ext_rcd rcd

265: -- Cursor to get the extract record id for hidden and Not hidden records
266: -- =============================================================================
267: CURSOR csr_ext_rcd_id_hidden(c_rcd_type_cd IN Varchar2) IS
268: SELECT rcd.ext_rcd_id
269: FROM ben_ext_rcd rcd
270: ,ben_ext_rcd_in_file rin
271: ,ben_ext_dfn dfn
272: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
273: AND rin.ext_file_id = dfn.ext_file_id

Line 270: ,ben_ext_rcd_in_file rin

266: -- =============================================================================
267: CURSOR csr_ext_rcd_id_hidden(c_rcd_type_cd IN Varchar2) IS
268: SELECT rcd.ext_rcd_id
269: FROM ben_ext_rcd rcd
270: ,ben_ext_rcd_in_file rin
271: ,ben_ext_dfn dfn
272: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
273: AND rin.ext_file_id = dfn.ext_file_id
274: AND rin.ext_rcd_id = rcd.ext_rcd_id

Line 634: ,ben_ext_rcd rcd

630: AND active_flag = 'Y')
631: AND NOT EXISTS( SELECT 1
632: FROM ben_ext_rslt_dtl dtl
633: ,ben_ext_rslt res
634: ,ben_ext_rcd rcd
635: ,ben_ext_rcd_in_file rin
636: ,ben_ext_dfn dfn
637: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
638: FROM pqp_extract_attributes

Line 635: ,ben_ext_rcd_in_file rin

631: AND NOT EXISTS( SELECT 1
632: FROM ben_ext_rslt_dtl dtl
633: ,ben_ext_rslt res
634: ,ben_ext_rcd rcd
635: ,ben_ext_rcd_in_file rin
636: ,ben_ext_dfn dfn
637: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
638: FROM pqp_extract_attributes
639: WHERE ext_dfn_type = 'NL_FPR')

Line 1368: (p_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE

1364: -- ============================================================================
1365: -- ~ Update_Record_Values :
1366: -- ============================================================================
1367: PROCEDURE Update_Record_Values
1368: (p_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
1369: ,p_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
1370: ,p_data_element_value IN ben_ext_rslt_dtl.val_01%TYPE
1371: ,p_data_ele_seqnum IN Number
1372: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE

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

1370: ,p_data_element_value IN ben_ext_rslt_dtl.val_01%TYPE
1371: ,p_data_ele_seqnum IN Number
1372: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
1373: ) IS
1374: CURSOR csr_seqnum (c_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
1375: ,c_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
1376: ) IS
1377: SELECT der.ext_data_elmt_id,
1378: der.seq_num,

Line 1907: ,p_ext_dtl_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE

1903: PROCEDURE Process_Ext_Rslt_Dtl_Rec
1904: (p_assignment_id IN per_all_assignments.assignment_id%TYPE
1905: ,p_organization_id IN per_all_assignments.organization_id%TYPE DEFAULT NULL
1906: ,p_effective_date IN Date
1907: ,p_ext_dtl_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
1908: ,p_rslt_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
1909: ,p_asgaction_no IN Number DEFAULT NULL
1910: ,p_error_message OUT NOCOPY Varchar2) IS
1911:

Line 2476: ,ben_ext_rcd rcd

2472: CURSOR c_rec05_sent (c_asg_seq IN VARCHAR2) IS
2473: SELECT 1
2474: FROM ben_ext_rslt_dtl dtl
2475: ,ben_ext_rslt res
2476: ,ben_ext_rcd rcd
2477: ,ben_ext_rcd_in_file rin
2478: ,ben_ext_dfn dfn
2479: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
2480: FROM pqp_extract_attributes

Line 2477: ,ben_ext_rcd_in_file rin

2473: SELECT 1
2474: FROM ben_ext_rslt_dtl dtl
2475: ,ben_ext_rslt res
2476: ,ben_ext_rcd rcd
2477: ,ben_ext_rcd_in_file rin
2478: ,ben_ext_dfn dfn
2479: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
2480: FROM pqp_extract_attributes
2481: WHERE ext_dfn_type = 'NL_FPR')

Line 3277: ,ben_ext_rcd rcd

3273: ,c_pt_code IN VARCHAR2) IS
3274: SELECT fnd_number.canonical_to_number(val_06)/100 basis
3275: FROM ben_ext_rslt_dtl dtl
3276: ,ben_ext_rslt res
3277: ,ben_ext_rcd rcd
3278: ,ben_ext_rcd_in_file rin
3279: ,ben_ext_dfn dfn
3280: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
3281: FROM pqp_extract_attributes

Line 3278: ,ben_ext_rcd_in_file rin

3274: SELECT fnd_number.canonical_to_number(val_06)/100 basis
3275: FROM ben_ext_rslt_dtl dtl
3276: ,ben_ext_rslt res
3277: ,ben_ext_rcd rcd
3278: ,ben_ext_rcd_in_file rin
3279: ,ben_ext_dfn dfn
3280: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
3281: FROM pqp_extract_attributes
3282: WHERE ext_dfn_type = 'NL_FPR')

Line 3302: ,ben_ext_rcd rcd

3298: ,TRUNC(res.eff_dt) eff_dt
3299: , val_05 code
3300: FROM ben_ext_rslt_dtl dtl
3301: ,ben_ext_rslt res
3302: ,ben_ext_rcd rcd
3303: ,ben_ext_rcd_in_file rin
3304: ,ben_ext_dfn dfn
3305: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
3306: FROM pqp_extract_attributes

Line 3303: ,ben_ext_rcd_in_file rin

3299: , val_05 code
3300: FROM ben_ext_rslt_dtl dtl
3301: ,ben_ext_rslt res
3302: ,ben_ext_rcd rcd
3303: ,ben_ext_rcd_in_file rin
3304: ,ben_ext_dfn dfn
3305: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
3306: FROM pqp_extract_attributes
3307: WHERE ext_dfn_type = 'NL_FPR')

Line 3327: ,ben_ext_rcd rcd

3323: ,c_poj_cd IN VARCHAR2) IS
3324: SELECT 1
3325: FROM ben_ext_rslt_dtl dtl
3326: ,ben_ext_rslt res
3327: ,ben_ext_rcd rcd
3328: ,ben_ext_rcd_in_file rin
3329: ,ben_ext_dfn dfn
3330: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
3331: FROM pqp_extract_attributes

Line 3328: ,ben_ext_rcd_in_file rin

3324: SELECT 1
3325: FROM ben_ext_rslt_dtl dtl
3326: ,ben_ext_rslt res
3327: ,ben_ext_rcd rcd
3328: ,ben_ext_rcd_in_file rin
3329: ,ben_ext_dfn dfn
3330: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
3331: FROM pqp_extract_attributes
3332: WHERE ext_dfn_type = 'NL_FPR')

Line 3352: ,ben_ext_rcd rcd

3348: ,c_code IN VARCHAR2) IS
3349: SELECT fnd_number.canonical_to_number(val_06)/100 amount
3350: FROM ben_ext_rslt_dtl dtl
3351: ,ben_ext_rslt res
3352: ,ben_ext_rcd rcd
3353: ,ben_ext_rcd_in_file rin
3354: ,ben_ext_dfn dfn
3355: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
3356: FROM pqp_extract_attributes

Line 3353: ,ben_ext_rcd_in_file rin

3349: SELECT fnd_number.canonical_to_number(val_06)/100 amount
3350: FROM ben_ext_rslt_dtl dtl
3351: ,ben_ext_rslt res
3352: ,ben_ext_rcd rcd
3353: ,ben_ext_rcd_in_file rin
3354: ,ben_ext_dfn dfn
3355: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
3356: FROM pqp_extract_attributes
3357: WHERE ext_dfn_type = 'NL_FPR')

Line 3379: ,ben_ext_rcd rcd

3375: ,c_code IN VARCHAR2) IS
3376: SELECT fnd_number.canonical_to_number(val_06)/100 amount
3377: FROM ben_ext_rslt_dtl dtl
3378: ,ben_ext_rslt res
3379: ,ben_ext_rcd rcd
3380: ,ben_ext_rcd_in_file rin
3381: ,ben_ext_dfn dfn
3382: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
3383: FROM pqp_extract_attributes

Line 3380: ,ben_ext_rcd_in_file rin

3376: SELECT fnd_number.canonical_to_number(val_06)/100 amount
3377: FROM ben_ext_rslt_dtl dtl
3378: ,ben_ext_rslt res
3379: ,ben_ext_rcd rcd
3380: ,ben_ext_rcd_in_file rin
3381: ,ben_ext_dfn dfn
3382: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
3383: FROM pqp_extract_attributes
3384: WHERE ext_dfn_type = 'NL_FPR')

Line 5779: FROM ben_ext_rcd rcd

5775: rin.seq_num,
5776: rin.hide_flag,
5777: rcd.ext_rcd_id,
5778: rcd.rcd_type_cd
5779: FROM ben_ext_rcd rcd
5780: ,ben_ext_rcd_in_file rin
5781: ,ben_ext_dfn dfn
5782: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
5783: AND rin.ext_file_id = dfn.ext_file_id

Line 5780: ,ben_ext_rcd_in_file rin

5776: rin.hide_flag,
5777: rcd.ext_rcd_id,
5778: rcd.rcd_type_cd
5779: FROM ben_ext_rcd rcd
5780: ,ben_ext_rcd_in_file rin
5781: ,ben_ext_dfn dfn
5782: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
5783: AND rin.ext_file_id = dfn.ext_file_id
5784: AND rin.ext_rcd_id = rcd.ext_rcd_id

Line 8302: ,ben_ext_rcd rcd

8298: CURSOR c_rec_02_sent(c_asg_seq_no IN VARCHAR2 ) IS
8299: SELECT 1
8300: FROM ben_ext_rslt_dtl dtl
8301: ,ben_ext_rslt res
8302: ,ben_ext_rcd rcd
8303: ,ben_ext_rcd_in_file rin
8304: ,ben_ext_dfn dfn
8305: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
8306: FROM pqp_extract_attributes

Line 8303: ,ben_ext_rcd_in_file rin

8299: SELECT 1
8300: FROM ben_ext_rslt_dtl dtl
8301: ,ben_ext_rslt res
8302: ,ben_ext_rcd rcd
8303: ,ben_ext_rcd_in_file rin
8304: ,ben_ext_dfn dfn
8305: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
8306: FROM pqp_extract_attributes
8307: WHERE ext_dfn_type = 'NL_FPR')

Line 8491: ,ben_ext_rcd rcd

8487: CURSOR c_rec_04_sent(c_asg_seq_no IN VARCHAR2 ) IS
8488: SELECT 1
8489: FROM ben_ext_rslt_dtl dtl
8490: ,ben_ext_rslt res
8491: ,ben_ext_rcd rcd
8492: ,ben_ext_rcd_in_file rin
8493: ,ben_ext_dfn dfn
8494: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
8495: FROM pqp_extract_attributes

Line 8492: ,ben_ext_rcd_in_file rin

8488: SELECT 1
8489: FROM ben_ext_rslt_dtl dtl
8490: ,ben_ext_rslt res
8491: ,ben_ext_rcd rcd
8492: ,ben_ext_rcd_in_file rin
8493: ,ben_ext_dfn dfn
8494: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
8495: FROM pqp_extract_attributes
8496: WHERE ext_dfn_type = 'NL_FPR')

Line 8902: ,ben_ext_rcd rcd

8898: ,c_asg_seq_no IN VARCHAR2 ) IS
8899: SELECT 1
8900: FROM ben_ext_rslt_dtl dtl
8901: ,ben_ext_rslt res
8902: ,ben_ext_rcd rcd
8903: ,ben_ext_rcd_in_file rin
8904: ,ben_ext_dfn dfn
8905: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
8906: FROM pqp_extract_attributes

Line 8903: ,ben_ext_rcd_in_file rin

8899: SELECT 1
8900: FROM ben_ext_rslt_dtl dtl
8901: ,ben_ext_rslt res
8902: ,ben_ext_rcd rcd
8903: ,ben_ext_rcd_in_file rin
8904: ,ben_ext_dfn dfn
8905: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
8906: FROM pqp_extract_attributes
8907: WHERE ext_dfn_type = 'NL_FPR')

Line 11082: ,ben_ext_rcd rcd

11078: SELECT dtl.val_07,
11079: DECODE(dtl.val_09,' ','A')
11080: FROM ben_ext_rslt_dtl dtl
11081: ,ben_ext_rslt res
11082: ,ben_ext_rcd rcd
11083: ,ben_ext_rcd_in_file rin
11084: ,ben_ext_dfn dfn
11085: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
11086: FROM pqp_extract_attributes

Line 11083: ,ben_ext_rcd_in_file rin

11079: DECODE(dtl.val_09,' ','A')
11080: FROM ben_ext_rslt_dtl dtl
11081: ,ben_ext_rslt res
11082: ,ben_ext_rcd rcd
11083: ,ben_ext_rcd_in_file rin
11084: ,ben_ext_dfn dfn
11085: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
11086: FROM pqp_extract_attributes
11087: WHERE ext_dfn_type = 'NL_FPR')

Line 11106: ,ben_ext_rcd rcd

11102: ,c_in_term_date IN VARCHAR2) IS
11103: SELECT 1
11104: FROM ben_ext_rslt_dtl dtl
11105: ,ben_ext_rslt res
11106: ,ben_ext_rcd rcd
11107: ,ben_ext_rcd_in_file rin
11108: ,ben_ext_dfn dfn
11109: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
11110: FROM pqp_extract_attributes

Line 11107: ,ben_ext_rcd_in_file rin

11103: SELECT 1
11104: FROM ben_ext_rslt_dtl dtl
11105: ,ben_ext_rslt res
11106: ,ben_ext_rcd rcd
11107: ,ben_ext_rcd_in_file rin
11108: ,ben_ext_dfn dfn
11109: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
11110: FROM pqp_extract_attributes
11111: WHERE ext_dfn_type = 'NL_FPR')

Line 11186: ,ben_ext_rcd rcd

11182: CURSOR c_rec05_sent IS
11183: SELECT 1
11184: FROM ben_ext_rslt_dtl dtl
11185: ,ben_ext_rslt res
11186: ,ben_ext_rcd rcd
11187: ,ben_ext_rcd_in_file rin
11188: ,ben_ext_dfn dfn
11189: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
11190: FROM pqp_extract_attributes

Line 11187: ,ben_ext_rcd_in_file rin

11183: SELECT 1
11184: FROM ben_ext_rslt_dtl dtl
11185: ,ben_ext_rslt res
11186: ,ben_ext_rcd rcd
11187: ,ben_ext_rcd_in_file rin
11188: ,ben_ext_dfn dfn
11189: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
11190: FROM pqp_extract_attributes
11191: WHERE ext_dfn_type = 'NL_FPR')

Line 14728: l_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;

14724: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
14725: l_main_rec csr_rslt_dtl%ROWTYPE;
14726: l_new_rec csr_rslt_dtl%ROWTYPE;
14727: l_effective_date Date;
14728: l_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
14729: l_record_num Varchar2(20);
14730: l_return_value Varchar2(2);
14731: l_last_name per_all_people_f.last_name%TYPE;
14732: l_dob VARCHAR2(8);

Line 16754: FROM ben_ext_rcd rcd

16750: -- Cursor to get the record id for Rec 05
16751: --
16752: CURSOR csr_rcd_05_id IS
16753: SELECT rcd.ext_rcd_id,rin.seq_num
16754: FROM ben_ext_rcd rcd
16755: ,ben_ext_rcd_in_file rin
16756: ,ben_ext_dfn dfn
16757: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
16758: AND rin.ext_file_id = dfn.ext_file_id

Line 16755: ,ben_ext_rcd_in_file rin

16751: --
16752: CURSOR csr_rcd_05_id IS
16753: SELECT rcd.ext_rcd_id,rin.seq_num
16754: FROM ben_ext_rcd rcd
16755: ,ben_ext_rcd_in_file rin
16756: ,ben_ext_dfn dfn
16757: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
16758: AND rin.ext_file_id = dfn.ext_file_id
16759: AND rin.ext_rcd_id = rcd.ext_rcd_id

Line 16778: l_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;

16774: AND val_10 = '00000000'
16775: AND val_17 = '00000000'
16776: AND business_group_id = p_business_group_id;
16777:
16778: l_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
16779: l_ext_main_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
16780: l_proc_name Varchar2(150):= g_proc_name||'Sort_Post_Process';
16781: l_return_value Number := 0; --0= Sucess, -1=Error ;
16782: l_tmp_person_id Number;

Line 16779: l_ext_main_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;

16775: AND val_17 = '00000000'
16776: AND business_group_id = p_business_group_id;
16777:
16778: l_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
16779: l_ext_main_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
16780: l_proc_name Varchar2(150):= g_proc_name||'Sort_Post_Process';
16781: l_return_value Number := 0; --0= Sucess, -1=Error ;
16782: l_tmp_person_id Number;
16783: l_tmp_org_id Number;