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.IGC_CBC_VALIDATIONS_PKG dependencies on GL_PERIOD_STATUSES

Line 241: l_closing_status gl_period_statuses.closing_status%TYPE;

237: l_posting_flag gl_code_combinations.detail_posting_allowed_flag%TYPE;
238: l_enabled_flag gl_code_combinations.enabled_flag%TYPE;
239: l_start_date gl_code_combinations.start_date_active%TYPE;
240: l_end_date gl_code_combinations.end_date_active%TYPE;
241: l_closing_status gl_period_statuses.closing_status%TYPE;
242: l_period_name igc_cbc_je_lines.period_name%TYPE;
243: l_period_set_name igc_cbc_je_lines.period_set_name%TYPE;
244: l_quarter_num igc_cbc_je_lines.quarter_num%TYPE;
245: l_period_num igc_cbc_je_lines.period_num%TYPE;

Line 521: gl_period_statuses FPER,

517: FROM igc_cbc_summary_templates_v GST,
518: psa_efc_summary_budgets ST,
519: gl_budget_versions BVR,
520: gl_budgets BUD,
521: gl_period_statuses FPER,
522: gl_period_statuses LPER
523: WHERE GST.template_id IN
524: ( SELECT template_id
525: FROM gl_account_hierarchies

Line 522: gl_period_statuses LPER

518: psa_efc_summary_budgets ST,
519: gl_budget_versions BVR,
520: gl_budgets BUD,
521: gl_period_statuses FPER,
522: gl_period_statuses LPER
523: WHERE GST.template_id IN
524: ( SELECT template_id
525: FROM gl_account_hierarchies
526: WHERE set_of_books_id = :1

Line 565: -- gl_period_statuses fper,

561: -- ( SELECT asg.range_id
562: -- FROM gl_budget_assignment_ranges asg,
563: -- gl_budget_versions bvr,
564: -- gl_budgets bud,
565: -- gl_period_statuses fper,
566: -- gl_period_statuses lper
567: -- WHERE asg.funding_budget_version_id IS NOT NULL
568: -- AND asg.funding_budget_version_id=bvr.budget_version_id
569: -- AND bvr.budget_name=bud.budget_name

Line 566: -- gl_period_statuses lper

562: -- FROM gl_budget_assignment_ranges asg,
563: -- gl_budget_versions bvr,
564: -- gl_budgets bud,
565: -- gl_period_statuses fper,
566: -- gl_period_statuses lper
567: -- WHERE asg.funding_budget_version_id IS NOT NULL
568: -- AND asg.funding_budget_version_id=bvr.budget_version_id
569: -- AND bvr.budget_name=bud.budget_name
570: -- AND fper.set_of_books_id = p_set_of_books_id

Line 588: gl_period_statuses fper,

584: igc_cbc_ba_ranges BAR,
585: gl_budget_assignment_ranges asg,
586: gl_budget_versions bvr,
587: gl_budgets bud,
588: gl_period_statuses fper,
589: gl_period_statuses lper
590: /*R12 Uptake - Commented for compilation Bug No 6341012*/
591: -- WHERE GBA.set_of_books_id = p_set_of_books_id
592: WHERE GBA.ledger_id = p_set_of_books_id

Line 589: gl_period_statuses lper

585: gl_budget_assignment_ranges asg,
586: gl_budget_versions bvr,
587: gl_budgets bud,
588: gl_period_statuses fper,
589: gl_period_statuses lper
590: /*R12 Uptake - Commented for compilation Bug No 6341012*/
591: -- WHERE GBA.set_of_books_id = p_set_of_books_id
592: WHERE GBA.ledger_id = p_set_of_books_id
593: /*R12 Uptake - Commented for compilation Bug No 6341012*/

Line 1015: FROM gl_period_statuses GPS,

1011: GP.period_set_name,
1012: GPS.period_num,
1013: GPS.period_year,
1014: GPS.quarter_num
1015: FROM gl_period_statuses GPS,
1016: gl_sets_of_books GP
1017: WHERE GPS.set_of_books_id = p_sob_id
1018: AND GPS.application_id = l_gl_application_id
1019: AND GPS.adjustment_period_flag = 'N'

Line 1037: FROM gl_period_statuses GPS,

1033: GP.period_set_name,
1034: GPS.period_num,
1035: GPS.period_year,
1036: GPS.quarter_num
1037: FROM gl_period_statuses GPS,
1038: gl_sets_of_books GP
1039: WHERE GPS.set_of_books_id = p_sob_id
1040: AND GPS.application_id = l_gl_application_id
1041: AND GPS.adjustment_period_flag = 'N'