DBA Data[Home] [Help]

APPS.PA_FP_CI_IMPLEMENT_PKG dependencies on PA_PROJ_ELEMENTS_UTILS

Line 534: ORDER BY PA_PROJ_ELEMENTS_UTILS.GET_DISPLAY_SEQUENCE(ra.task_id);

530: bl.other_rejection_code IS NULL AND
531: bl.pc_cur_conv_rejection_code IS NULL AND
532: bl.pfc_cur_conv_rejection_code IS NULL
533: GROUP BY ra.task_id HAVING NVL( SUM(nvl(bl.txn_revenue,0)) , 0) <> 0
534: ORDER BY PA_PROJ_ELEMENTS_UTILS.GET_DISPLAY_SEQUENCE(ra.task_id);
535: EXCEPTION
536: WHEN NO_DATA_FOUND THEN
537: NULL;
538: END;

Line 577: ORDER BY PA_PROJ_ELEMENTS_UTILS.GET_DISPLAY_SEQUENCE(pt.top_task_id);

573: AND bl.other_rejection_code IS NULL
574: AND bl.pc_cur_conv_rejection_code IS NULL
575: AND bl.pfc_cur_conv_rejection_code IS NULL
576: GROUP BY pt.top_task_id HAVING NVL( SUM(nvl(bl.txn_revenue,0)) , 0) <> 0
577: ORDER BY PA_PROJ_ELEMENTS_UTILS.GET_DISPLAY_SEQUENCE(pt.top_task_id);
578: EXCEPTION
579: WHEN NO_DATA_FOUND THEN
580: NULL;
581: END;