DBA Data[Home] [Help]

APPS.PJI_PJP_PRG_PERF_ALL dependencies on PA_FIN_PLAN_TYPES_B

Line 892: FROM PA_FIN_PLAN_TYPES_B

888: END IF;
889:
890: SELECT fin_plan_type_id
891: INTO l_plan_type_id
892: FROM PA_FIN_PLAN_TYPES_B
893: WHERE USE_FOR_WORKPLAN_FLAG='Y';
894:
895: INSERT /*+ parallel(PJP1) */ INTO PJI_FP_AGGR_PJP1 PJP1
896: (

Line 5647: FROM pa_fin_plan_types_b

5643:
5644: -- Bug# 5208322 : the workplan plan_type_id is stored in l_workplan_type_id
5645: begin
5646: SELECT fin_plan_type_id into l_workplan_type_id
5647: FROM pa_fin_plan_types_b
5648: WHERE use_for_workplan_flag = 'Y';
5649: exception
5650: when no_data_found then
5651: l_workplan_type_id := NULL;