DBA Data[Home] [Help]

APPS.GMF_VALIDATIONS_PVT dependencies on CM_ALYS_MST

Line 414: --| on cm_alys_mst |

410: --| Validates Cost Analysis Code |
411: --| |
412: --| DESCRIPTION |
413: --| This function validates that the Cost Analysis Code exists |
414: --| on cm_alys_mst |
415: --| |
416: --| PARAMETERS |
417: --| p_Cost_Analysis_Code IN VARCHAR2(4) - Cost Analysis Code |
418: --| |

Line 431: p_Cost_Analysis_Code IN cm_alys_mst.Cost_Analysis_Code%TYPE

427: -- Func end of comments
428:
429: FUNCTION Validate_Analysis_Code
430: (
431: p_Cost_Analysis_Code IN cm_alys_mst.Cost_Analysis_Code%TYPE
432: )
433: RETURN BOOLEAN
434: IS
435: CURSOR Cur_analysis_code

Line 440: cm_alys_mst

436: IS
437: SELECT
438: cost_analysis_code
439: FROM
440: cm_alys_mst
441: WHERE
442: cost_analysis_code = p_Cost_Analysis_Code
443: AND delete_mark = 0;
444:

Line 445: l_Cost_Analysis_Code cm_alys_mst.Cost_Analysis_Code%TYPE ;

441: WHERE
442: cost_analysis_code = p_Cost_Analysis_Code
443: AND delete_mark = 0;
444:
445: l_Cost_Analysis_Code cm_alys_mst.Cost_Analysis_Code%TYPE ;
446:
447: BEGIN
448:
449: OPEN Cur_analysis_code;