DBA Data[Home] [Help]

APPS.PA_FP_EDIT_LINE_PKG dependencies on GL_PERIOD_STATUSES

Line 3103: ,GL_PERIOD_STATUSES g

3099: ,'null' pa_period
3100: ,g.period_name gl_period
3101: ,g.period_name period_name
3102: FROM PA_IMPLEMENTATIONS i
3103: ,GL_PERIOD_STATUSES g
3104: WHERE g.set_of_books_id = i.set_of_books_id
3105: AND g.application_id = pa_period_process_pkg.application_id
3106: AND g.adjustment_period_flag = 'N'
3107: AND g.start_date = p_preceding_prd_start_date;

Line 3123: ,GL_PERIOD_STATUSES g

3119: ,'null' pa_period /* this value is never used */
3120: ,g.period_name gl_period
3121: ,g.period_name period_name
3122: FROM PA_IMPLEMENTATIONS i
3123: ,GL_PERIOD_STATUSES g
3124: WHERE g.set_of_books_id = i.set_of_books_id
3125: AND g.application_id = pa_period_process_pkg.application_id
3126: AND g.adjustment_period_flag = 'N'
3127: AND g.start_date BETWEEN p_period_profile_start_date AND p_period_profile_end_date;

Line 3153: ,GL_PERIOD_STATUSES g

3149: ,'null' pa_period
3150: ,g.period_name gl_period
3151: ,g.period_name period_name
3152: FROM PA_IMPLEMENTATIONS i
3153: ,GL_PERIOD_STATUSES g
3154: WHERE g.set_of_books_id = i.set_of_books_id
3155: AND g.application_id = pa_period_process_pkg.application_id
3156: AND g.adjustment_period_flag = 'N'
3157: AND g.start_date = p_succeeding_prd_start_date;