DBA Data[Home] [Help]

APPS.PA_FP_EDIT_LINE_PKG dependencies on PA_PERIOD_PROCESS_PKG

Line 3105: AND g.application_id = pa_period_process_pkg.application_id

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;
3108:
3109: END IF;

Line 3125: AND g.application_id = pa_period_process_pkg.application_id

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;
3128:
3129: pa_debug.g_err_stage := TO_CHAR(l_stage)||'inserted ' || sql%rowcount || ' records';

Line 3155: AND g.application_id = pa_period_process_pkg.application_id

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;
3158:
3159: END IF;