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.HRI_OPL_BEN_DIM_REFRESH dependencies on HRI_CS_COMPOBJ_CT

Line 186: FROM HRI_CS_COMPOBJ_CT oppd

182: AND pln.effective_end_date
183: AND pln.invk_flx_cr_pl_flag = 'N'
184: AND pln.imptd_incm_calc_cd IS NULL
185: AND NOT EXISTS (SELECT 'x'
186: FROM HRI_CS_COMPOBJ_CT oppd
187: WHERE oppd.plip_id = cpp.plip_id
188: AND oppd.oiplip_id = -1);
189: --
190: CURSOR c_oiplip IS

Line 202: FROM HRI_CS_COMPOBJ_CT oppd

198: AND opp.effective_end_date
199: AND l_effective_date BETWEEN cop.effective_start_date
200: AND cop.effective_end_date
201: AND NOT EXISTS (SELECT 'x'
202: FROM HRI_CS_COMPOBJ_CT oppd
203: WHERE oppd.oiplip_id = opp.oiplip_id);
204:
205: --
206:

Line 350: -- (4) Populate dimension table HRI_CS_COMPOBJ_CT

346: END LOOP;
347: --
348: output('Populated Plan In Program Dimension: ' || to_char(sysdate,'HH24:MI:SS'));
349: --
350: -- (4) Populate dimension table HRI_CS_COMPOBJ_CT
351: --
352: FOR l_oiplip_row in c_oiplip LOOP
353: --
354: INSERT INTO HRI_CS_COMPOBJ_CT

Line 354: INSERT INTO HRI_CS_COMPOBJ_CT

350: -- (4) Populate dimension table HRI_CS_COMPOBJ_CT
351: --
352: FOR l_oiplip_row in c_oiplip LOOP
353: --
354: INSERT INTO HRI_CS_COMPOBJ_CT
355: ( compobj_sk_pk
356: , oiplip_id
357: , oipl_id
358: , opt_id

Line 372: ( HRI_CS_COMPOBJ_CT_s.nextval

368: , CREATED_BY
369: , CREATION_DATE
370: )
371: VALUES
372: ( HRI_CS_COMPOBJ_CT_s.nextval
373: , l_oiplip_row.oiplip_id
374: , l_oiplip_row.oipl_id
375: , l_oiplip_row.opt_id
376: , l_oiplip_row.pl_id

Line 391: -- (5) Populate dimension table HRI_CS_COMPOBJ_CT for Enrollments at Plan Level

387: );
388: --
389: END LOOP;
390: --
391: -- (5) Populate dimension table HRI_CS_COMPOBJ_CT for Enrollments at Plan Level
392: --
393: FOR l_plip_ernt_pl_row in c_plip_ernt_pl LOOP
394: --
395: INSERT INTO HRI_CS_COMPOBJ_CT

Line 395: INSERT INTO HRI_CS_COMPOBJ_CT

391: -- (5) Populate dimension table HRI_CS_COMPOBJ_CT for Enrollments at Plan Level
392: --
393: FOR l_plip_ernt_pl_row in c_plip_ernt_pl LOOP
394: --
395: INSERT INTO HRI_CS_COMPOBJ_CT
396: ( compobj_sk_pk
397: , oiplip_id
398: , oipl_id
399: , opt_id

Line 413: ( HRI_CS_COMPOBJ_CT_s.nextval

409: , CREATED_BY
410: , CREATION_DATE
411: )
412: VALUES
413: ( HRI_CS_COMPOBJ_CT_s.nextval
414: , -1
415: , -1
416: , NULL
417: , l_plip_ernt_pl_row.pl_id

Line 552: DELETE FROM HRI_CS_COMPOBJ_CT oppd

548: WHERE cpp.plip_id = cppd.plip_id);
549: --
550: -- Option In Plan In Program Dimension
551: --
552: DELETE FROM HRI_CS_COMPOBJ_CT oppd
553: WHERE oppd.oiplip_id <> -1
554: AND NOT EXISTS (SELECT 'x'
555: FROM ben_oiplip_f opp
556: WHERE opp.oiplip_id = oppd.oiplip_id);

Line 560: DELETE FROM hri_cs_compobj_ct oppd

556: WHERE opp.oiplip_id = oppd.oiplip_id);
557: --
558: -- Plan In Program Dimension (Enrol In Plan And Option - Checked)
559: --
560: DELETE FROM hri_cs_compobj_ct oppd
561: WHERE oppd.oiplip_id = -1
562: AND oppd.plip_id IS NOT NULL
563: AND ( NOT EXISTS (
564: SELECT 'x'

Line 754: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_COMPOBJ_CT_WHO DISABLE');

750: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_CO_PGM_CT_WHO DISABLE');
751: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_CO_PGMH_PTIP_CT_WHO DISABLE');
752: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_CO_PGMH_PLIP_CT_WHO DISABLE');
753: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_CO_RPGH_PIRG_CT_WHO DISABLE');
754: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_COMPOBJ_CT_WHO DISABLE');
755: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_TIME_BENRL_PRD_CT_WHO DISABLE');
756: --
757: -- Truncate the target table prior to full refresh.
758: --

Line 762: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_schema || '.HRI_CS_COMPOBJ_CT';

758: --
759: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_schema || '.HRI_CS_CO_PGM_CT';
760: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_schema || '.HRI_CS_CO_PGMH_PTIP_CT';
761: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_schema || '.HRI_CS_CO_PGMH_PLIP_CT';
762: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_schema || '.HRI_CS_COMPOBJ_CT';
763: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_schema || '.HRI_CS_CO_RPGH_PIRG_CT';
764: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_schema || '.HRI_CS_TIME_BENRL_PRD_CT';
765: --
766: -- Write timing information to log

Line 862: -- (4) Populate dimension table HRI_CS_COMPOBJ_CT

858: END LOOP;
859: --
860: output('Populated Plan In Program Dimension: ' || to_char(sysdate,'HH24:MI:SS'));
861: --
862: -- (4) Populate dimension table HRI_CS_COMPOBJ_CT
863: --
864: FOR l_oiplip_row in c_oiplip LOOP
865: --
866: INSERT INTO HRI_CS_COMPOBJ_CT

Line 866: INSERT INTO HRI_CS_COMPOBJ_CT

862: -- (4) Populate dimension table HRI_CS_COMPOBJ_CT
863: --
864: FOR l_oiplip_row in c_oiplip LOOP
865: --
866: INSERT INTO HRI_CS_COMPOBJ_CT
867: ( compobj_sk_pk
868: , oiplip_id
869: , oipl_id
870: , opt_id

Line 884: ( HRI_CS_COMPOBJ_CT_s.nextval

880: , CREATED_BY
881: , CREATION_DATE
882: )
883: VALUES
884: ( HRI_CS_COMPOBJ_CT_s.nextval
885: , l_oiplip_row.oiplip_id
886: , l_oiplip_row.oipl_id
887: , l_oiplip_row.opt_id
888: , l_oiplip_row.pl_id

Line 903: -- (5) Populate dimension table HRI_CS_COMPOBJ_CT for Enrollments at Plan Level

899: );
900: --
901: END LOOP;
902: --
903: -- (5) Populate dimension table HRI_CS_COMPOBJ_CT for Enrollments at Plan Level
904: --
905: FOR l_plip_ernt_pl_row in c_plip_ernt_pl LOOP
906: --
907: INSERT INTO HRI_CS_COMPOBJ_CT

Line 907: INSERT INTO HRI_CS_COMPOBJ_CT

903: -- (5) Populate dimension table HRI_CS_COMPOBJ_CT for Enrollments at Plan Level
904: --
905: FOR l_plip_ernt_pl_row in c_plip_ernt_pl LOOP
906: --
907: INSERT INTO HRI_CS_COMPOBJ_CT
908: ( compobj_sk_pk
909: , oiplip_id
910: , oipl_id
911: , opt_id

Line 924: ( HRI_CS_COMPOBJ_CT_s.nextval

920: , CREATED_BY
921: , CREATION_DATE
922: )
923: VALUES
924: ( HRI_CS_COMPOBJ_CT_s.nextval
925: , -1
926: , -1
927: , NULL
928: , l_plip_ernt_pl_row.pl_id

Line 1045: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_COMPOBJ_CT_WHO ENABLE');

1041: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_CO_PGM_CT_WHO ENABLE');
1042: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_CO_PGMH_PTIP_CT_WHO ENABLE');
1043: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_CO_PGMH_PLIP_CT_WHO ENABLE');
1044: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_CO_RPGH_PIRG_CT_WHO ENABLE');
1045: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_COMPOBJ_CT_WHO ENABLE');
1046: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_TIME_BENRL_PRD_CT_WHO ENABLE');
1047: --
1048: EXCEPTION
1049: --