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.GMF_PERIODCLOSE_PUB dependencies on GMF_PERIOD_STATUSES

Line 723: FROM gmf_period_statuses gps

719: cp_end_date DATE
720: )
721: IS
722: SELECT gps.period_id
723: FROM gmf_period_statuses gps
724: WHERE gps.legal_entity_id = cp_le_id
725: AND gps.cost_type_id = cp_ct_id
726: AND gps.end_date = cp_end_date
727: ORDER BY gps.end_date desc

Line 730: l_prev_period_id gmf_period_statuses.period_id%TYPE;

726: AND gps.end_date = cp_end_date
727: ORDER BY gps.end_date desc
728: ;
729:
730: l_prev_period_id gmf_period_statuses.period_id%TYPE;
731: l_open_periods_cnt BINARY_INTEGER;
732:
733: BEGIN
734:

Line 759: gmf_period_statuses gps,

755: --
756: SELECT oap.period_year, oap.period_num
757: INTO x_inv_period_year, x_inv_period_num
758: FROM org_acct_periods oap,
759: gmf_period_statuses gps,
760: hr_organization_information hoi
761: WHERE gps.period_id = l_prev_period_id
762: AND gps.legal_entity_id = hoi.org_information2
763: AND hoi.org_information_context = 'Accounting Information'