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 1347: (p_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE

1343: -- ============================================================================
1344: -- ~ Update_Record_Values :
1345: -- ============================================================================
1346: PROCEDURE Update_Record_Values
1347: (p_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
1348: ,p_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
1349: ,p_data_element_value IN ben_ext_rslt_dtl.val_01%TYPE
1350: ,p_data_ele_seqnum IN Number
1351: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE

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

1349: ,p_data_element_value IN ben_ext_rslt_dtl.val_01%TYPE
1350: ,p_data_ele_seqnum IN Number
1351: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
1352: ) IS
1353: CURSOR csr_seqnum (c_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
1354: ,c_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
1355: ) IS
1356: SELECT der.ext_data_elmt_id,
1357: der.seq_num,

Line 1886: ,p_ext_dtl_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE

1882: PROCEDURE Process_Ext_Rslt_Dtl_Rec
1883: (p_assignment_id IN per_all_assignments.assignment_id%TYPE
1884: ,p_organization_id IN per_all_assignments.organization_id%TYPE DEFAULT NULL
1885: ,p_effective_date IN Date
1886: ,p_ext_dtl_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
1887: ,p_rslt_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
1888: ,p_asgaction_no IN Number DEFAULT NULL
1889: ,p_error_message OUT NOCOPY Varchar2) IS
1890:

Line 2455: ,ben_ext_rcd rcd

2451: CURSOR c_rec05_sent (c_asg_seq IN VARCHAR2) IS
2452: SELECT 1
2453: FROM ben_ext_rslt_dtl dtl
2454: ,ben_ext_rslt res
2455: ,ben_ext_rcd rcd
2456: ,ben_ext_rcd_in_file rin
2457: ,ben_ext_dfn dfn
2458: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
2459: FROM pqp_extract_attributes

Line 2456: ,ben_ext_rcd_in_file rin

2452: SELECT 1
2453: FROM ben_ext_rslt_dtl dtl
2454: ,ben_ext_rslt res
2455: ,ben_ext_rcd rcd
2456: ,ben_ext_rcd_in_file rin
2457: ,ben_ext_dfn dfn
2458: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
2459: FROM pqp_extract_attributes
2460: WHERE ext_dfn_type = 'NL_FPR')

Line 3256: ,ben_ext_rcd rcd

3252: ,c_pt_code IN VARCHAR2) IS
3253: SELECT fnd_number.canonical_to_number(val_06)/100 basis
3254: FROM ben_ext_rslt_dtl dtl
3255: ,ben_ext_rslt res
3256: ,ben_ext_rcd rcd
3257: ,ben_ext_rcd_in_file rin
3258: ,ben_ext_dfn dfn
3259: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
3260: FROM pqp_extract_attributes

Line 3257: ,ben_ext_rcd_in_file rin

3253: SELECT fnd_number.canonical_to_number(val_06)/100 basis
3254: FROM ben_ext_rslt_dtl dtl
3255: ,ben_ext_rslt res
3256: ,ben_ext_rcd rcd
3257: ,ben_ext_rcd_in_file rin
3258: ,ben_ext_dfn dfn
3259: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
3260: FROM pqp_extract_attributes
3261: WHERE ext_dfn_type = 'NL_FPR')

Line 3281: ,ben_ext_rcd rcd

3277: ,TRUNC(res.eff_dt) eff_dt
3278: , val_05 code
3279: FROM ben_ext_rslt_dtl dtl
3280: ,ben_ext_rslt res
3281: ,ben_ext_rcd rcd
3282: ,ben_ext_rcd_in_file rin
3283: ,ben_ext_dfn dfn
3284: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
3285: FROM pqp_extract_attributes

Line 3282: ,ben_ext_rcd_in_file rin

3278: , val_05 code
3279: FROM ben_ext_rslt_dtl dtl
3280: ,ben_ext_rslt res
3281: ,ben_ext_rcd rcd
3282: ,ben_ext_rcd_in_file rin
3283: ,ben_ext_dfn dfn
3284: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
3285: FROM pqp_extract_attributes
3286: WHERE ext_dfn_type = 'NL_FPR')

Line 3306: ,ben_ext_rcd rcd

3302: ,c_poj_cd IN VARCHAR2) IS
3303: SELECT 1
3304: FROM ben_ext_rslt_dtl dtl
3305: ,ben_ext_rslt res
3306: ,ben_ext_rcd rcd
3307: ,ben_ext_rcd_in_file rin
3308: ,ben_ext_dfn dfn
3309: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
3310: FROM pqp_extract_attributes

Line 3307: ,ben_ext_rcd_in_file rin

3303: SELECT 1
3304: FROM ben_ext_rslt_dtl dtl
3305: ,ben_ext_rslt res
3306: ,ben_ext_rcd rcd
3307: ,ben_ext_rcd_in_file rin
3308: ,ben_ext_dfn dfn
3309: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
3310: FROM pqp_extract_attributes
3311: WHERE ext_dfn_type = 'NL_FPR')

Line 3331: ,ben_ext_rcd rcd

3327: ,c_code IN VARCHAR2) IS
3328: SELECT fnd_number.canonical_to_number(val_06)/100 amount
3329: FROM ben_ext_rslt_dtl dtl
3330: ,ben_ext_rslt res
3331: ,ben_ext_rcd rcd
3332: ,ben_ext_rcd_in_file rin
3333: ,ben_ext_dfn dfn
3334: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
3335: FROM pqp_extract_attributes

Line 3332: ,ben_ext_rcd_in_file rin

3328: SELECT fnd_number.canonical_to_number(val_06)/100 amount
3329: FROM ben_ext_rslt_dtl dtl
3330: ,ben_ext_rslt res
3331: ,ben_ext_rcd rcd
3332: ,ben_ext_rcd_in_file rin
3333: ,ben_ext_dfn dfn
3334: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
3335: FROM pqp_extract_attributes
3336: WHERE ext_dfn_type = 'NL_FPR')

Line 3358: ,ben_ext_rcd rcd

3354: ,c_code IN VARCHAR2) IS
3355: SELECT fnd_number.canonical_to_number(val_06)/100 amount
3356: FROM ben_ext_rslt_dtl dtl
3357: ,ben_ext_rslt res
3358: ,ben_ext_rcd rcd
3359: ,ben_ext_rcd_in_file rin
3360: ,ben_ext_dfn dfn
3361: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
3362: FROM pqp_extract_attributes

Line 3359: ,ben_ext_rcd_in_file rin

3355: SELECT fnd_number.canonical_to_number(val_06)/100 amount
3356: FROM ben_ext_rslt_dtl dtl
3357: ,ben_ext_rslt res
3358: ,ben_ext_rcd rcd
3359: ,ben_ext_rcd_in_file rin
3360: ,ben_ext_dfn dfn
3361: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
3362: FROM pqp_extract_attributes
3363: WHERE ext_dfn_type = 'NL_FPR')

Line 5590: FROM ben_ext_rcd rcd

5586: rin.seq_num,
5587: rin.hide_flag,
5588: rcd.ext_rcd_id,
5589: rcd.rcd_type_cd
5590: FROM ben_ext_rcd rcd
5591: ,ben_ext_rcd_in_file rin
5592: ,ben_ext_dfn dfn
5593: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
5594: AND rin.ext_file_id = dfn.ext_file_id

Line 5591: ,ben_ext_rcd_in_file rin

5587: rin.hide_flag,
5588: rcd.ext_rcd_id,
5589: rcd.rcd_type_cd
5590: FROM ben_ext_rcd rcd
5591: ,ben_ext_rcd_in_file rin
5592: ,ben_ext_dfn dfn
5593: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
5594: AND rin.ext_file_id = dfn.ext_file_id
5595: AND rin.ext_rcd_id = rcd.ext_rcd_id

Line 7963: ,ben_ext_rcd rcd

7959: CURSOR c_rec_02_sent(c_asg_seq_no IN VARCHAR2 ) IS
7960: SELECT 1
7961: FROM ben_ext_rslt_dtl dtl
7962: ,ben_ext_rslt res
7963: ,ben_ext_rcd rcd
7964: ,ben_ext_rcd_in_file rin
7965: ,ben_ext_dfn dfn
7966: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
7967: FROM pqp_extract_attributes

Line 7964: ,ben_ext_rcd_in_file rin

7960: SELECT 1
7961: FROM ben_ext_rslt_dtl dtl
7962: ,ben_ext_rslt res
7963: ,ben_ext_rcd rcd
7964: ,ben_ext_rcd_in_file rin
7965: ,ben_ext_dfn dfn
7966: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
7967: FROM pqp_extract_attributes
7968: WHERE ext_dfn_type = 'NL_FPR')

Line 8152: ,ben_ext_rcd rcd

8148: CURSOR c_rec_04_sent(c_asg_seq_no IN VARCHAR2 ) IS
8149: SELECT 1
8150: FROM ben_ext_rslt_dtl dtl
8151: ,ben_ext_rslt res
8152: ,ben_ext_rcd rcd
8153: ,ben_ext_rcd_in_file rin
8154: ,ben_ext_dfn dfn
8155: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
8156: FROM pqp_extract_attributes

Line 8153: ,ben_ext_rcd_in_file rin

8149: SELECT 1
8150: FROM ben_ext_rslt_dtl dtl
8151: ,ben_ext_rslt res
8152: ,ben_ext_rcd rcd
8153: ,ben_ext_rcd_in_file rin
8154: ,ben_ext_dfn dfn
8155: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
8156: FROM pqp_extract_attributes
8157: WHERE ext_dfn_type = 'NL_FPR')

Line 8563: ,ben_ext_rcd rcd

8559: ,c_asg_seq_no IN VARCHAR2 ) IS
8560: SELECT 1
8561: FROM ben_ext_rslt_dtl dtl
8562: ,ben_ext_rslt res
8563: ,ben_ext_rcd rcd
8564: ,ben_ext_rcd_in_file rin
8565: ,ben_ext_dfn dfn
8566: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
8567: FROM pqp_extract_attributes

Line 8564: ,ben_ext_rcd_in_file rin

8560: SELECT 1
8561: FROM ben_ext_rslt_dtl dtl
8562: ,ben_ext_rslt res
8563: ,ben_ext_rcd rcd
8564: ,ben_ext_rcd_in_file rin
8565: ,ben_ext_dfn dfn
8566: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
8567: FROM pqp_extract_attributes
8568: WHERE ext_dfn_type = 'NL_FPR')

Line 10743: ,ben_ext_rcd rcd

10739: SELECT dtl.val_07,
10740: DECODE(dtl.val_09,' ','A')
10741: FROM ben_ext_rslt_dtl dtl
10742: ,ben_ext_rslt res
10743: ,ben_ext_rcd rcd
10744: ,ben_ext_rcd_in_file rin
10745: ,ben_ext_dfn dfn
10746: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
10747: FROM pqp_extract_attributes

Line 10744: ,ben_ext_rcd_in_file rin

10740: DECODE(dtl.val_09,' ','A')
10741: FROM ben_ext_rslt_dtl dtl
10742: ,ben_ext_rslt res
10743: ,ben_ext_rcd rcd
10744: ,ben_ext_rcd_in_file rin
10745: ,ben_ext_dfn dfn
10746: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
10747: FROM pqp_extract_attributes
10748: WHERE ext_dfn_type = 'NL_FPR')

Line 10767: ,ben_ext_rcd rcd

10763: ,c_in_term_date IN VARCHAR2) IS
10764: SELECT 1
10765: FROM ben_ext_rslt_dtl dtl
10766: ,ben_ext_rslt res
10767: ,ben_ext_rcd rcd
10768: ,ben_ext_rcd_in_file rin
10769: ,ben_ext_dfn dfn
10770: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
10771: FROM pqp_extract_attributes

Line 10768: ,ben_ext_rcd_in_file rin

10764: SELECT 1
10765: FROM ben_ext_rslt_dtl dtl
10766: ,ben_ext_rslt res
10767: ,ben_ext_rcd rcd
10768: ,ben_ext_rcd_in_file rin
10769: ,ben_ext_dfn dfn
10770: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
10771: FROM pqp_extract_attributes
10772: WHERE ext_dfn_type = 'NL_FPR')

Line 10847: ,ben_ext_rcd rcd

10843: CURSOR c_rec05_sent IS
10844: SELECT 1
10845: FROM ben_ext_rslt_dtl dtl
10846: ,ben_ext_rslt res
10847: ,ben_ext_rcd rcd
10848: ,ben_ext_rcd_in_file rin
10849: ,ben_ext_dfn dfn
10850: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
10851: FROM pqp_extract_attributes

Line 10848: ,ben_ext_rcd_in_file rin

10844: SELECT 1
10845: FROM ben_ext_rslt_dtl dtl
10846: ,ben_ext_rslt res
10847: ,ben_ext_rcd rcd
10848: ,ben_ext_rcd_in_file rin
10849: ,ben_ext_dfn dfn
10850: WHERE dfn.ext_dfn_id IN (SELECT ext_dfn_id
10851: FROM pqp_extract_attributes
10852: WHERE ext_dfn_type = 'NL_FPR')

Line 14351: l_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;

14347: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
14348: l_main_rec csr_rslt_dtl%ROWTYPE;
14349: l_new_rec csr_rslt_dtl%ROWTYPE;
14350: l_effective_date Date;
14351: l_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
14352: l_record_num Varchar2(20);
14353: l_return_value Varchar2(2);
14354: l_last_name per_all_people_f.last_name%TYPE;
14355: l_dob VARCHAR2(8);

Line 16364: FROM ben_ext_rcd rcd

16360: -- Cursor to get the record id for Rec 05
16361: --
16362: CURSOR csr_rcd_05_id IS
16363: SELECT rcd.ext_rcd_id,rin.seq_num
16364: FROM ben_ext_rcd rcd
16365: ,ben_ext_rcd_in_file rin
16366: ,ben_ext_dfn dfn
16367: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
16368: AND rin.ext_file_id = dfn.ext_file_id

Line 16365: ,ben_ext_rcd_in_file rin

16361: --
16362: CURSOR csr_rcd_05_id IS
16363: SELECT rcd.ext_rcd_id,rin.seq_num
16364: FROM ben_ext_rcd rcd
16365: ,ben_ext_rcd_in_file rin
16366: ,ben_ext_dfn dfn
16367: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
16368: AND rin.ext_file_id = dfn.ext_file_id
16369: AND rin.ext_rcd_id = rcd.ext_rcd_id

Line 16388: l_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;

16384: AND val_10 = '00000000'
16385: AND val_17 = '00000000'
16386: AND business_group_id = p_business_group_id;
16387:
16388: l_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
16389: l_ext_main_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
16390: l_proc_name Varchar2(150):= g_proc_name||'Sort_Post_Process';
16391: l_return_value Number := 0; --0= Sucess, -1=Error ;
16392: l_tmp_person_id Number;

Line 16389: l_ext_main_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;

16385: AND val_17 = '00000000'
16386: AND business_group_id = p_business_group_id;
16387:
16388: l_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
16389: l_ext_main_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
16390: l_proc_name Varchar2(150):= g_proc_name||'Sort_Post_Process';
16391: l_return_value Number := 0; --0= Sucess, -1=Error ;
16392: l_tmp_person_id Number;
16393: l_tmp_org_id Number;