APPS.GMF_GLSYNCH dependencies on OP_TERM_MST

Line 284: exists in op_term_mst table */

280: END IF;
281: END; /* Validate_Rate_Type */
282:
283: /* This function validates that the Terms Codes
284: exists in op_term_mst table */
285:
286: PROCEDURE Validate_Terms_Code(
287: pi_table_name in varchar2,
288: pi_key_name in varchar2,

Line 295: FROM op_term_mst

291: pi_field_value in out NOCOPY varchar2) IS
292: CURSOR C_Val_Terms_Code (v_of_terms_code in varchar2,
293: v_terms_code out varchar2) IS
294: SELECT terms_code
295: FROM op_term_mst
296: WHERE of_terms_code = v_of_terms_code;
297: v_temp_terms_code op_term_mst.terms_code%TYPE;
298: BEGIN
299: IF pi_field_value IS NOT NULL THEN

Line 297: v_temp_terms_code op_term_mst.terms_code%TYPE;

293: v_terms_code out varchar2) IS
294: SELECT terms_code
295: FROM op_term_mst
296: WHERE of_terms_code = v_of_terms_code;
297: v_temp_terms_code op_term_mst.terms_code%TYPE;
298: BEGIN
299: IF pi_field_value IS NOT NULL THEN
300: IF C_Val_Terms_Code%ISOPEN THEN
301: CLOSE C_Val_Terms_Code;

Line 871: FROM op_term_mst

867:
868: FUNCTION Validate_Terms_Code(pi_field_value in varchar2) return boolean IS
869: CURSOR C_Val_Terms_Code (v_of_terms_code in varchar2) IS
870: SELECT 1
871: FROM op_term_mst
872: WHERE of_terms_code = v_of_terms_code;
873: BEGIN
874: IF pi_field_value IS NOT NULL THEN
875: IF C_Val_Terms_Code%ISOPEN THEN