DBA Data[Home] [Help]

APPS.GMF_VALIDATIONS_PVT dependencies on CM_ALYS_MST

Line 416: --| on cm_alys_mst |

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

Line 433: p_Cost_Analysis_Code IN cm_alys_mst.Cost_Analysis_Code%TYPE

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

Line 442: cm_alys_mst

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

Line 447: l_Cost_Analysis_Code cm_alys_mst.Cost_Analysis_Code%TYPE ;

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