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_RPGH_PIRG_CT

Line 216: FROM HRI_CS_CO_RPGH_PIRG_CT rgrd

212: AND rgr.pgm_id = pgmd.pgm_id
213: AND l_effective_date BETWEEN rgr.effective_start_date
214: AND rgr.effective_end_date
215: AND NOT EXISTS (SELECT 'x'
216: FROM HRI_CS_CO_RPGH_PIRG_CT rgrd
217: WHERE rgrd.RPTGTYP_ID = rgr.rptg_grp_id
218: AND rgrd.pgm_id = rgr.pgm_id);
219: --
220: CURSOR c_pgm_enrt_perd

Line 434: -- (6) Populate dimension table HRI_CS_CO_RPGH_PIRG_CT for Reporting Group Information

430: END LOOP;
431: --
432: output('Populated Compensation Object Dimension: ' || to_char(sysdate,'HH24:MI:SS'));
433: --
434: -- (6) Populate dimension table HRI_CS_CO_RPGH_PIRG_CT for Reporting Group Information
435: --
436: FOR l_popl_rptg_grp_row in c_popl_rptg_grp LOOP
437: --
438: INSERT INTO HRI_CS_CO_RPGH_PIRG_CT

Line 438: INSERT INTO HRI_CS_CO_RPGH_PIRG_CT

434: -- (6) Populate dimension table HRI_CS_CO_RPGH_PIRG_CT for Reporting Group Information
435: --
436: FOR l_popl_rptg_grp_row in c_popl_rptg_grp LOOP
437: --
438: INSERT INTO HRI_CS_CO_RPGH_PIRG_CT
439: ( PIRG_SK_PK
440: , RPTGTYP_ID
441: , pgm_id
442: , LAST_UPDATE_DATE

Line 449: ( HRI_CS_CO_RPGH_PIRG_CT_S.nextval

445: , CREATED_BY
446: , CREATION_DATE
447: )
448: VALUES
449: ( HRI_CS_CO_RPGH_PIRG_CT_S.nextval
450: , l_popl_rptg_grp_row.rptg_grp_id
451: , l_popl_rptg_grp_row.pgm_id
452: , l_current_time
453: , l_user_id

Line 590: DELETE FROM HRI_CS_CO_RPGH_PIRG_CT rgrd

586: WHERE enp.enrt_perd_id = enpd.enrt_perd_id);
587: --
588: -- Reporting Group Dimension
589: --
590: DELETE FROM HRI_CS_CO_RPGH_PIRG_CT rgrd
591: WHERE NOT EXISTS (SELECT 'x'
592: FROM ben_popl_rptg_grp_F rgr
593: WHERE rgr.rptg_grp_id = rgrd.RPTGTYP_ID
594: AND rgr.pgm_id = rgrd.pgm_id);

Line 753: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_CO_RPGH_PIRG_CT_WHO DISABLE');

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

Line 763: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_schema || '.HRI_CS_CO_RPGH_PIRG_CT';

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
767: --

Line 944: -- (6) Populate dimension table HRI_CS_CO_RPGH_PIRG_CT for Reporting Group Information

940: END LOOP;
941: --
942: output('Populated Compensation Object Dimension: ' || to_char(sysdate,'HH24:MI:SS'));
943: --
944: -- (6) Populate dimension table HRI_CS_CO_RPGH_PIRG_CT for Reporting Group Information
945: --
946: FOR l_popl_rptg_grp_row in c_popl_rptg_grp LOOP
947: --
948: INSERT INTO HRI_CS_CO_RPGH_PIRG_CT

Line 948: INSERT INTO HRI_CS_CO_RPGH_PIRG_CT

944: -- (6) Populate dimension table HRI_CS_CO_RPGH_PIRG_CT for Reporting Group Information
945: --
946: FOR l_popl_rptg_grp_row in c_popl_rptg_grp LOOP
947: --
948: INSERT INTO HRI_CS_CO_RPGH_PIRG_CT
949: ( PIRG_SK_PK
950: , RPTGTYP_ID
951: , pgm_id
952: , LAST_UPDATE_DATE

Line 959: ( HRI_CS_CO_RPGH_PIRG_CT_S.nextval

955: , CREATED_BY
956: , CREATION_DATE
957: )
958: VALUES
959: ( HRI_CS_CO_RPGH_PIRG_CT_S.nextval
960: , l_popl_rptg_grp_row.rptg_grp_id
961: , l_popl_rptg_grp_row.pgm_id
962: , l_current_time
963: , l_user_id

Line 1044: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_CO_RPGH_PIRG_CT_WHO ENABLE');

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');
1047: --
1048: EXCEPTION

Line 1166: fnd_stats.gather_table_stats(g_schema, 'HRI_CS_CO_RPGH_PIRG_CT');

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');
1169: --
1170: -- Write timing information to log