APPS.GMF_VALIDATIONS_PVT dependencies on FM_FORM_EFF

Line 1271: --| on fm_form_eff |

1267: --| Validates Fmeff_Id |
1268: --| |
1269: --| DESCRIPTION |
1270: --| This function validates that the Effectivity Id exists |
1271: --| on fm_form_eff |
1272: --| |
1273: --| PARAMETERS |
1274: --| p_fneff_id IN VARCHAR2(8) - Effectivity Id |
1275: --| |

Line 1288: p_Fmeff_Id IN fm_form_eff.Fmeff_Id%TYPE

1284: -- Func end of comments
1285:
1286: FUNCTION Validate_Fmeff_Id
1287: (
1288: p_Fmeff_Id IN fm_form_eff.Fmeff_Id%TYPE
1289: )
1290: RETURN BOOLEAN
1291: IS
1292: CURSOR Cur_fmeff_id

Line 1297: fm_form_eff

1293: IS
1294: SELECT
1295: fmeff_id
1296: FROM
1297: fm_form_eff
1298: WHERE
1299: fmeff_id = p_fmeff_id
1300: AND delete_mark = 0;
1301:

Line 1302: l_fmeff_id fm_form_eff.fmeff_id%TYPE;

1298: WHERE
1299: fmeff_id = p_fmeff_id
1300: AND delete_mark = 0;
1301:
1302: l_fmeff_id fm_form_eff.fmeff_id%TYPE;
1303:
1304: BEGIN
1305:
1306: OPEN Cur_fmeff_id;