DBA Data[Home] [Help]

APPS.PA_FP_CI_IMPLEMENT_PKG dependencies on PA_PROJ_ELEMENTS_UTILS

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

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

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

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