DBA Data[Home] [Help]

APPS.PJI_REP_UTIL dependencies on PA_IMPLEMENTATIONS

Line 2755: from pa_implementations;

2751: END IF;
2752:
2753: /* Added for bug 9859878
2754: select same_pa_gl_period into l_same_pa_gl_period
2755: from pa_implementations;
2756: */
2757: /* Added for bug 12420222 */
2758: select same_pa_gl_period into l_same_pa_gl_period
2759: from pa_implementations_all where org_id =

Line 2759: from pa_implementations_all where org_id =

2755: from pa_implementations;
2756: */
2757: /* Added for bug 12420222 */
2758: select same_pa_gl_period into l_same_pa_gl_period
2759: from pa_implementations_all where org_id =
2760: (select org_id from pa_projects_all where project_id = p_project_id);
2761: /* Added for bug 12420222 */
2762:
2763: Derive_Slice_Name(p_project_id,

Line 2871: , pa_implementations paimp

2867: INTO l_report_date
2868: FROM
2869: pji_time_cal_period_v TIM
2870: , gl_period_statuses glps
2871: , pa_implementations paimp
2872: WHERE 1=1
2873: AND TIM.calendar_id = x_calendar_id
2874: AND paimp.set_of_books_id = glps.set_of_books_id
2875: AND glps.application_id = l_application_id

Line 2884: , pa_implementations paimp

2880: INTO l_report_date
2881: FROM
2882: pji_time_cal_period_v TIM
2883: , pa_periods_all pa
2884: , pa_implementations paimp
2885: WHERE 1=1
2886: AND TIM.calendar_id = x_calendar_id
2887: AND paimp.org_id = pa.org_id
2888: AND pa.period_name = TIM.NAME

Line 2898: , pa_implementations paimp

2894: INTO l_report_date
2895: FROM
2896: pji_time_cal_period_v TIM
2897: , gl_period_statuses glps
2898: , pa_implementations paimp
2899: WHERE 1=1
2900: AND TIM.calendar_id = x_calendar_id
2901: AND paimp.set_of_books_id = glps.set_of_books_id
2902: AND glps.application_id = 275

Line 2911: , pa_implementations paimp

2907: INTO l_report_date
2908: FROM
2909: pji_time_cal_period_v TIM
2910: , pa_periods_all pa
2911: , pa_implementations paimp
2912: WHERE 1=1
2913: AND TIM.calendar_id = x_calendar_id
2914: AND paimp.org_id = pa.org_id
2915: AND pa.period_name = TIM.NAME

Line 2925: , pa_implementations paimp

2921: INTO l_report_date
2922: FROM
2923: pji_time_cal_period_v TIM
2924: , gl_period_statuses glps
2925: , pa_implementations paimp
2926: WHERE 1=1
2927: AND TIM.calendar_id = x_calendar_id
2928: AND paimp.set_of_books_id = glps.set_of_books_id
2929: AND glps.application_id = l_application_id

Line 2938: , pa_implementations paimp

2934: INTO l_report_date
2935: FROM
2936: pji_time_cal_period_v TIM
2937: , pa_periods_all pa
2938: , pa_implementations paimp
2939: WHERE 1=1
2940: AND TIM.calendar_id = x_calendar_id
2941: AND paimp.org_id = pa.org_id
2942: AND pa.period_name = TIM.NAME