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.PQH_GIN_BUS dependencies on PQH_FR_GLOBAL_INDICES_F

Line 485: from pqh_fr_global_indices_f

481: IS
482: --
483: Cursor csr_INM_record_existence IS
484: Select null
485: from pqh_fr_global_indices_f
486: where type_of_record = 'INM';
487: --
488: l_value varchar2(10);
489:

Line 545: from pqh_fr_global_indices_f

541: Procedure chk_inm_existance(p_effective_date date)
542: IS
543: Cursor csr_ind_existance is
544: Select null
545: from pqh_fr_global_indices_f
546: where p_effective_date between effective_start_date and effective_end_date
547: and type_of_record = 'INM';
548: --
549: l_value varchar2(10);

Line 574: from pqh_fr_global_indices_f

570: Procedure chk_steps_exist_for_index(p_global_index_id number, p_effective_date date)
571: IS
572: Cursor csr_current_record IS
573: Select Gross_index
574: from pqh_fr_global_indices_f
575: where global_index_id = p_global_index_id
576: and p_effective_date between effective_start_date and effective_end_date;
577: --
578: l_gross_index number;

Line 606: from pqh_fr_global_indices_f

602: IS
603:
604: Cursor csr_unique is
605: Select null
606: from pqh_fr_global_indices_f
607: where gross_index =p_gross_index;
608: --
609: l_value varchar2(1);
610: Begin

Line 633: from pqh_fr_global_indices_f

629: IS
630:
631: Cursor csr_unique is
632: Select null
633: from pqh_fr_global_indices_f
634: where gross_index =p_gross_index
635: and increased_index = p_increased_index
636: and global_index_id <> p_global_index_id;
637: --