APPS.FV_FACTS_TBAL_TRANSACTIONS dependencies on GL_PERIOD_STATUSES

Line 433: From gl_period_statuses

429: period_num
430: Into v_begin_period_name,
431: v_fiscal_year,
432: v_begin_period_num
433: From gl_period_statuses
434: Where trunc(start_date) = trunc(vp_start_date)
435: and application_id = 101
436: and adjustment_period_flag = 'N'
437: and set_of_books_id = vp_set_of_books_id ;

Line 1029: and gjl.Period_Name NOT IN (Select Period_Name From GL_Period_Statuses

1025: gl_je_categories glc,
1026: gl_code_combinations glcc,
1027: fv_fund_parameters ffp
1028: Where gjl.code_combination_id = glcc.code_combination_id
1029: and gjl.Period_Name NOT IN (Select Period_Name From GL_Period_Statuses
1030: Where Adjustment_Period_Flag = '||''''||'Y'||''''||
1031: ' And set_of_books_id = ' || vp_set_of_books_id || ')
1032: AND gjl.Je_Header_Id = glh.Je_Header_Id
1033: and glh.je_Category = glc.Je_Category_Name