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.BEN_EXT_THREAD dependencies on BEN_EXT_RSLT_DTL

Line 159: 15-Dec-04 tjesumic 115.111 ext_rcd_in_file_id added to ben_Ext_rslt_dtl table

155: 13-aug-04 tjesumic 115.107 chg_actl_ct is truncated to validated the dates
156: 18-Nov-04 rpinjala 115.108 New procedure chk_pqp_extract added
157: 19-Nov-04 rpinjala 115.109 Changed chk_pqp_extract procedure.
158: 05-Dec-04 rpinjala 115.110 Changed chk_pqp_extract procedure.
159: 15-Dec-04 tjesumic 115.111 ext_rcd_in_file_id added to ben_Ext_rslt_dtl table
160: 01-Feb-05 tjesumic 115.112 300 elements allowed in a record
161: 08-Mar-05 tjesumic 115.113 check_asg_security changed for performance
162: 09-Mar-05 tjesumic 115.114 check_asg_security changed for performance
163: 22-Mar-05 tjesumic 115.115 CWB (CW) , subheader codes changes

Line 512: FROM ben_ext_rcd rcd, ben_ext_rslt_dtl rdtl

508: WHERE rslt.ext_rslt_id = p_ext_rslt_id;
509: --
510: cursor c_ext_rcd is
511: SELECT distinct rdtl.ext_rcd_id ext_rcd_id
512: FROM ben_ext_rcd rcd, ben_ext_rslt_dtl rdtl
513: WHERE rdtl.ext_rslt_id = p_ext_rslt_id
514: and rdtl.ext_rcd_id = rcd.ext_rcd_id
515: and rcd.rcd_type_cd in ('H','T');
516: --

Line 578: l_tot_string := 'UPDATE BEN_EXT_RSLT_DTL ' || l_tot_string

574: if l_tot_string is not null then
575: */
576: --
577: /*
578: l_tot_string := 'UPDATE BEN_EXT_RSLT_DTL ' || l_tot_string
579: || ' WHERE ext_rslt_id = ' || to_char(p_ext_rslt_id)
580: || ' AND ext_rcd_id = ' || to_char(rcd_rec.ext_rcd_id);
581:
582: */

Line 584: l_tot_string := 'UPDATE BEN_EXT_RSLT_DTL SET ' || l_col_name || ' = :VAL where ext_rslt_id = :RSLT_ID and ext_rcd_id = :RCD_ID' ;

580: || ' AND ext_rcd_id = ' || to_char(rcd_rec.ext_rcd_id);
581:
582: */
583:
584: l_tot_string := 'UPDATE BEN_EXT_RSLT_DTL SET ' || l_col_name || ' = :VAL where ext_rslt_id = :RSLT_ID and ext_rcd_id = :RCD_ID' ;
585:
586: DBMS_SQL.PARSE(l_cursor_id, l_tot_string, dbms_sql.v7);
587:
588:

Line 717: from ben_ext_rslt_dtl xrd

713:
714: cursor get_per_cnt (p_group_val_01 varchar2 ,
715: p_group_val_02 varchar2) is
716: select count(distinct person_id)
717: from ben_ext_rslt_dtl xrd
718: where xrd.ext_rslt_id = p_ext_rslt_id
719: and person_id not in (0, 999999999999)
720: and xrd.group_val_01 = p_group_val_01
721: and nvl(xrd.group_val_02,'-1') = nvl(p_group_val_02,'-1') ;

Line 727: from ben_ext_rslt_dtl xrd ,

723:
724: cursor get_dtl_cnt(p_group_val_01 varchar2 ,
725: p_group_val_02 varchar2) is
726: select count(*)
727: from ben_ext_rslt_dtl xrd ,
728: ben_ext_rcd_in_file erf
729: where xrd.ext_rslt_id = p_ext_rslt_id
730: and xrd.ext_rcd_id = erf.ext_rcd_id
731: and xrd.ext_rcd_in_file_id = erf.ext_rcd_in_file_id

Line 743: from ben_ext_rslt_dtl xrd ,

739:
740: cursor get_ttl_cnt(p_group_val_01 varchar2 ,
741: p_group_val_02 varchar2) is
742: select count(*)
743: from ben_ext_rslt_dtl xrd ,
744: ben_ext_rcd_in_file erf
745: where xrd.ext_rslt_id = p_ext_rslt_id
746: and xrd.ext_rcd_id = erf.ext_rcd_id
747: and xrd.ext_rcd_in_file_id = erf.ext_rcd_in_file_id

Line 1184: l_prmy_sort_val ben_ext_rslt_dtl.prmy_sort_val%TYPE; -- UTF8 varchar2(30);

1180: l_object_version_number number(15);
1181: --
1182: l_trans_num number(15);
1183: l_person_id number(15);
1184: l_prmy_sort_val ben_ext_rslt_dtl.prmy_sort_val%TYPE; -- UTF8 varchar2(30);
1185: l_scnd_sort_val ben_ext_rslt_dtl.scnd_sort_val%TYPE; -- UTF8 varchar2(30);
1186: l_exclude_this_rcd_flag boolean;
1187: l_write_rcd varchar2(1);
1188: l_elmt_name varchar2(2000) ;

Line 1185: l_scnd_sort_val ben_ext_rslt_dtl.scnd_sort_val%TYPE; -- UTF8 varchar2(30);

1181: --
1182: l_trans_num number(15);
1183: l_person_id number(15);
1184: l_prmy_sort_val ben_ext_rslt_dtl.prmy_sort_val%TYPE; -- UTF8 varchar2(30);
1185: l_scnd_sort_val ben_ext_rslt_dtl.scnd_sort_val%TYPE; -- UTF8 varchar2(30);
1186: l_exclude_this_rcd_flag boolean;
1187: l_write_rcd varchar2(1);
1188: l_elmt_name varchar2(2000) ;
1189: l_error_message varchar2(2000) ;

Line 1250: from ben_Ext_rslt_dtl xrd,

1246:
1247:
1248: cursor get_subtrl_cnt is
1249: select count(*)
1250: from ben_Ext_rslt_dtl xrd,
1251: ben_ext_rcd rcd,
1252: ben_ext_rcd_in_file erf
1253: where xrd.ext_rslt_id = p_ext_rslt_id
1254: and xrd.ext_rcd_id = erf.ext_rcd_id

Line 1539: ben_ext_rslt_dtl_api.create_ext_rslt_dtl

1535: if l_write_rcd = 'Y' then
1536: --
1537: -- call 'create ext detail api' here
1538: --
1539: ben_ext_rslt_dtl_api.create_ext_rslt_dtl
1540: (p_validate => false
1541: ,p_ext_rslt_dtl_id => l_ext_rslt_dtl_id
1542: ,p_prmy_sort_val => l_prmy_sort_val
1543: ,p_scnd_sort_val => l_scnd_sort_val

Line 1918: from ben_Ext_rslt_dtl xrd,

1914: select distinct
1915: xrd.group_val_01,
1916: xrd.group_val_02,
1917: nvl(xrd.ext_per_bg_id,-1) ext_per_bg_id
1918: from ben_Ext_rslt_dtl xrd,
1919: ben_ext_rcd rcd,
1920: ben_ext_rcd_in_file erf
1921: where xrd.ext_rslt_id = p_ext_rslt_id
1922: and xrd.ext_rcd_id = erf.ext_rcd_id

Line 2038: from ben_Ext_rslt_dtl xrd,

2034: --
2035:
2036: cursor get_subhdr_cnt is
2037: select count(*)
2038: from ben_Ext_rslt_dtl xrd,
2039: ben_ext_rcd rcd,
2040: ben_ext_rcd_in_file erf
2041: where xrd.ext_rslt_id = p_ext_rslt_id
2042: and xrd.ext_rcd_id = erf.ext_rcd_id

Line 2053: from ben_ext_rslt_dtl xrd , ben_ext_rcd_in_file erf

2049: --
2050:
2051: cursor get_dtl_cnt is
2052: select count(*)
2053: from ben_ext_rslt_dtl xrd , ben_ext_rcd_in_file erf
2054: where xrd.ext_rslt_id = p_ext_rslt_id
2055: and xrd.ext_rcd_id = erf.ext_rcd_id
2056: and xrd.ext_rcd_in_file_id = erf.ext_rcd_in_file_id
2057: and erf.ext_file_id = p_ext_file_id

Line 2062: -- from ben_ext_rslt_dtl xrd

2058: and erf.hide_flag = 'N'
2059: and person_id not in (0, 999999999999) ;
2060:
2061: -- select count(*)
2062: -- from ben_ext_rslt_dtl xrd
2063: -- where xrd.ext_rslt_id = p_ext_rslt_id;
2064: --
2065: cursor get_per_cnt is
2066: select count(distinct person_id)

Line 2067: from ben_ext_rslt_dtl xrd

2063: -- where xrd.ext_rslt_id = p_ext_rslt_id;
2064: --
2065: cursor get_per_cnt is
2066: select count(distinct person_id)
2067: from ben_ext_rslt_dtl xrd
2068: where xrd.ext_rslt_id = p_ext_rslt_id
2069: and person_id not in (0, 999999999999);
2070: --
2071: cursor get_err_cnt is

Line 4585: ' exists ( select group_val_01 from ben_ext_rslt_dtl erd where ' ||

4581: end if ;
4582: if l_pdl_val1 = 'PDLJOB' then
4583: l_dynamic_sql := l_dynamic_sql ||
4584: ' (select 1 from per_jobs job where job.job_id = ben_asg.job_id and ' ||
4585: ' exists ( select group_val_01 from ben_ext_rslt_dtl erd where ' ||
4586: ' erd.ext_rslt_id = ' || p_ext_rslt_id ||
4587: ' and group_val_01 is not null and group_val_01 = job.name ) ) ' ;
4588: elsif l_pdl_val1 = 'PDLPOS' then
4589: l_dynamic_sql := l_dynamic_sql ||

Line 4593: ' exists ( select group_val_01 from ben_ext_rslt_dtl erd where ' ||

4589: l_dynamic_sql := l_dynamic_sql ||
4590: ' (select 1 from HR_ALL_POSITIONS_F pos where pos.position_id = ben_asg.position_id and '||
4591: ' to_date(''' || to_char(p_effective_date,'DD-MM-RRRR') ||
4592: ''',''DD-MM-RRRR'') between pos.effective_start_date and pos.effective_end_date and ' ||
4593: ' exists ( select group_val_01 from ben_ext_rslt_dtl erd where ' ||
4594: ' erd.ext_rslt_id = ' || p_ext_rslt_id ||
4595: ' and group_val_01 is not null and group_val_01 = pos.name )) ' ;
4596:
4597: elsif l_pdl_val1 = 'PDLPAY' then

Line 4600: ' exists ( select group_val_01 from ben_ext_rslt_dtl erd where ' ||

4596:
4597: elsif l_pdl_val1 = 'PDLPAY' then
4598: l_dynamic_sql := l_dynamic_sql ||
4599: ' (select 1 from pay_payrolls pay where pay.payroll_id = ben_asg.payroll_id and ' ||
4600: ' exists ( select group_val_01 from ben_ext_rslt_dtl erd where ' ||
4601: ' erd.ext_rslt_id = ' || p_ext_rslt_id ||
4602: ' and group_val_01 is not null and group_val_01 = pay.payroll_name )) ' ;
4603: elsif l_pdl_val1 = 'PDLLOC' then
4604: l_dynamic_sql := l_dynamic_sql ||

Line 4608: ' and exists ( select group_val_01 from ben_ext_rslt_dtl erd where ' ||

4604: l_dynamic_sql := l_dynamic_sql ||
4605: ' (select 1 from hr_locations_all loc where loc.location_id = ben_asg.location_id ' ||
4606: ' and to_date(''' || to_char(p_effective_date,'DD-MM-RRRR') ||
4607: ''',''DD-MM-RRRR'') between loc.effective_start_date and loc.effective_end_date ' ||
4608: ' and exists ( select group_val_01 from ben_ext_rslt_dtl erd where ' ||
4609: ' erd.ext_rslt_id = ' || p_ext_rslt_id ||
4610: ' and group_val_01 is not null and group_val_01 = loc.location_code )) ' ;
4611: elsif l_pdl_val1 = 'PDLEAPP' then
4612: l_dynamic_sql := l_dynamic_sql ||

Line 4622: ' and exists ( select group_val_01 from ben_ext_rslt_dtl erd where ' ||

4618:
4619: elsif l_pdl_val1 = 'PDLGRD' then
4620: l_dynamic_sql := l_dynamic_sql ||
4621: ' (select 1 from per_grades grd where grd.grade_id = ben_asg.grade_id ' ||
4622: ' and exists ( select group_val_01 from ben_ext_rslt_dtl erd where ' ||
4623: ' erd.ext_rslt_id = ' || p_ext_rslt_id ||
4624: ' and group_val_01 is not null and group_val_01 = grd.name )) ' ;
4625:
4626: end if;

Line 6614: from ben_ext_rslt_dtl

6610:
6611: cursor c_xrdt (c_person_id number) is
6612: select ext_rslt_dtl_id,
6613: object_version_number
6614: from ben_ext_rslt_dtl
6615: where person_id = c_person_id
6616: and ext_rslt_id = p_ext_rslt_id ;
6617:
6618:

Line 6653: ben_EXT_RSLT_DTL_api.delete_EXT_RSLT_DTL

6649: hr_utility.set_location ('deleting '|| pact.person_id, 177);
6650: end if;
6651:
6652: l_object_version_number := xrdt.object_version_number ;
6653: ben_EXT_RSLT_DTL_api.delete_EXT_RSLT_DTL
6654: (p_ext_rslt_dtl_id => xrdt.ext_rslt_dtl_id
6655: ,p_object_version_number => l_object_version_number
6656: );
6657: end loop ;