APPS.PO_DAILY_CONVERSION_TYPES_SV1 dependencies on GL_DAILY_CONVERSION_TYPES

Line 20: gl_daily_conversion_types_v view */

16: BEGIN
17: x_progress := '010';
18:
19: /* check to see if the given rate_type_code is a valid on in
20: gl_daily_conversion_types_v view */
21:
22: SELECT count(*)
23: INTO x_temp
24: FROM gl_daily_conversion_types_v

Line 24: FROM gl_daily_conversion_types_v

20: gl_daily_conversion_types_v view */
21:
22: SELECT count(*)
23: INTO x_temp
24: FROM gl_daily_conversion_types_v
25: WHERE conversion_type = x_rate_type_code;
26:
27: IF x_temp = 0 THEN
28: RETURN FALSE; /* validation fails */

Line 56: /* get the rate_type_code from gl_daily_conversion_types table

52: BEGIN
53:
54: X_progress := '010';
55:
56: /* get the rate_type_code from gl_daily_conversion_types table
57: based on the rate_type value provided from input parameter */
58:
59: SELECT conversion_type
60: INTO X_rate_type_v

Line 61: FROM gl_daily_conversion_types

57: based on the rate_type value provided from input parameter */
58:
59: SELECT conversion_type
60: INTO X_rate_type_v
61: FROM gl_daily_conversion_types
62: WHERE user_conversion_type = X_rate_type;
63:
64: RETURN X_rate_type_v;
65: