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_CO_PGMH_PTIP_CT

Line 143: FROM hri_cs_co_pgmh_ptip_ct ctpd

139: AND EXISTS (SELECT 'x'
140: FROM hri_cs_co_pgm_ct pgmd
141: WHERE pgmd.pgm_id = ctp.pgm_id)
142: AND NOT EXISTS (SELECT 'x'
143: FROM hri_cs_co_pgmh_ptip_ct ctpd
144: WHERE ctpd.ptip_id = ctp.ptip_id);
145:
146: --
147: CURSOR c_plip IS

Line 150: FROM ben_plip_f cpp, ben_pl_f pln, hri_cs_co_pgmh_ptip_ct ctpd

146: --
147: CURSOR c_plip IS
148: SELECT cpp.plip_id plip_id, cpp.pl_id pl_id, cpp.pgm_id pgm_id,
149: ctpd.ptip_id ptip_id, ctpd.pl_typ_id pl_typ_id, cpp.ordr_num plip_ordr_num
150: FROM ben_plip_f cpp, ben_pl_f pln, hri_cs_co_pgmh_ptip_ct ctpd
151: WHERE cpp.pl_id = pln.pl_id
152: AND pln.pl_typ_id = ctpd.pl_typ_id
153: AND cpp.pgm_id = ctpd.pgm_id
154: AND pln.invk_flx_cr_pl_flag = 'N'

Line 167: FROM ben_plip_f cpp, ben_pl_f pln, hri_cs_co_pgmh_ptip_ct ctpd

163: --
164: CURSOR c_plip_ernt_pl IS
165: SELECT cpp.plip_id plip_id, cpp.pl_id pl_id, cpp.pgm_id pgm_id,
166: ctpd.ptip_id ptip_id, ctpd.pl_typ_id pl_typ_id
167: FROM ben_plip_f cpp, ben_pl_f pln, hri_cs_co_pgmh_ptip_ct ctpd
168: WHERE cpp.pl_id = pln.pl_id
169: AND pln.pl_typ_id = ctpd.pl_typ_id
170: AND cpp.pgm_id = ctpd.pgm_id
171: AND ( pln.enrt_pl_opt_flag = 'Y'

Line 283: -- (2) Populate dimension table HRI_CS_CO_PGMH_PTIP_CT

279: END LOOP;
280: --
281: output('Populated Program Dimension: ' || to_char(sysdate,'HH24:MI:SS'));
282: --
283: -- (2) Populate dimension table HRI_CS_CO_PGMH_PTIP_CT
284: --
285: FOR l_ptip_row in c_ptip LOOP
286: --
287: INSERT INTO HRI_CS_CO_PGMH_PTIP_CT

Line 287: INSERT INTO HRI_CS_CO_PGMH_PTIP_CT

283: -- (2) Populate dimension table HRI_CS_CO_PGMH_PTIP_CT
284: --
285: FOR l_ptip_row in c_ptip LOOP
286: --
287: INSERT INTO HRI_CS_CO_PGMH_PTIP_CT
288: ( ptip_id
289: , pl_typ_id
290: , PGM_ID
291: , ptip_ordr_num

Line 538: DELETE FROM HRI_CS_CO_PGMH_PTIP_CT ctpd

534: WHERE pgm.pgm_id = pgmd.pgm_id);
535: --
536: -- Plan Type In Program Dimension
537: --
538: DELETE FROM HRI_CS_CO_PGMH_PTIP_CT ctpd
539: WHERE NOT EXISTS (SELECT 'x'
540: FROM ben_ptip_f ctp
541: WHERE ctp.ptip_id = ctpd.ptip_id);
542: --

Line 658: FROM ben_plip_f cpp, ben_pl_f pln, hri_cs_co_pgmh_ptip_ct ctpd

654: CURSOR c_plip
655: IS
656: SELECT cpp.plip_id plip_id, cpp.pl_id pl_id, cpp.pgm_id pgm_id,
657: ctpd.ptip_id ptip_id, ctpd.pl_typ_id pl_typ_id, cpp.ordr_num plip_ordr_num
658: FROM ben_plip_f cpp, ben_pl_f pln, hri_cs_co_pgmh_ptip_ct ctpd
659: WHERE cpp.pl_id = pln.pl_id
660: AND pln.pl_typ_id = ctpd.pl_typ_id
661: AND cpp.pgm_id = ctpd.pgm_id
662: AND pln.invk_flx_cr_pl_flag = 'N'

Line 674: FROM ben_plip_f cpp, ben_pl_f pln, hri_cs_co_pgmh_ptip_ct ctpd

670: CURSOR c_plip_ernt_pl
671: IS
672: SELECT cpp.plip_id plip_id, cpp.pl_id pl_id, cpp.pgm_id pgm_id,
673: ctpd.ptip_id ptip_id, ctpd.pl_typ_id pl_typ_id
674: FROM ben_plip_f cpp, ben_pl_f pln, hri_cs_co_pgmh_ptip_ct ctpd
675: WHERE cpp.pl_id = pln.pl_id
676: AND pln.pl_typ_id = ctpd.pl_typ_id
677: AND cpp.pgm_id = ctpd.pgm_id
678: AND ( pln.enrt_pl_opt_flag = 'Y'

Line 751: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_CO_PGMH_PTIP_CT_WHO DISABLE');

747: --
748: -- Disable the WHO Triggers
749: --
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');

Line 760: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_schema || '.HRI_CS_CO_PGMH_PTIP_CT';

756: --
757: -- Truncate the target table prior to full refresh.
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';

Line 796: -- (2) Populate dimension table HRI_CS_CO_PGMH_PTIP_CT

792: END LOOP;
793: --
794: output('Populated Program Dimension: ' || to_char(sysdate,'HH24:MI:SS'));
795: --
796: -- (2) Populate dimension table HRI_CS_CO_PGMH_PTIP_CT
797: --
798: FOR l_ptip_row in c_ptip LOOP
799: --
800: INSERT INTO HRI_CS_CO_PGMH_PTIP_CT

Line 800: INSERT INTO HRI_CS_CO_PGMH_PTIP_CT

796: -- (2) Populate dimension table HRI_CS_CO_PGMH_PTIP_CT
797: --
798: FOR l_ptip_row in c_ptip LOOP
799: --
800: INSERT INTO HRI_CS_CO_PGMH_PTIP_CT
801: ( ptip_id
802: , pl_typ_id
803: , PGM_ID
804: , ptip_ordr_num

Line 1042: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_CO_PGMH_PTIP_CT_WHO ENABLE');

1038: --
1039: -- Enable the WHO triggers
1040: --
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');

Line 1164: fnd_stats.gather_table_stats(g_schema, 'HRI_CS_CO_PGMH_PTIP_CT');

1160: --
1161: -- Gather index stats
1162: --
1163: fnd_stats.gather_table_stats(g_schema, 'HRI_CS_CO_PGM_CT');
1164: fnd_stats.gather_table_stats(g_schema, 'HRI_CS_CO_PGMH_PTIP_CT');
1165: fnd_stats.gather_table_stats(g_schema, 'HRI_CS_CO_PGMH_PLIP_CT');
1166: fnd_stats.gather_table_stats(g_schema, 'HRI_CS_CO_RPGH_PIRG_CT');
1167: fnd_stats.gather_table_stats(g_schema, 'HRI_CS_TIME_BENRL_PRD_CT');
1168: fnd_stats.gather_table_stats(g_schema, 'HRI_CS_CO_PGM_CT');