DBA Data[Home] [Help]

APPS.GME_RESCHEDULE_BATCH_PVT dependencies on GMD_STATUS

Line 77: FROM gmd_status gs, gmd_recipe_validity_rules grvr

73:
74: CURSOR cur_get_status_type (v_validity_rule_id NUMBER)
75: IS
76: SELECT status_type
77: FROM gmd_status gs, gmd_recipe_validity_rules grvr
78: WHERE grvr.recipe_validity_rule_id = v_validity_rule_id
79: AND status_code = grvr.validity_rule_status;
80:
81: l_status_type gmd_status.status_type%TYPE;

Line 81: l_status_type gmd_status.status_type%TYPE;

77: FROM gmd_status gs, gmd_recipe_validity_rules grvr
78: WHERE grvr.recipe_validity_rule_id = v_validity_rule_id
79: AND status_code = grvr.validity_rule_status;
80:
81: l_status_type gmd_status.status_type%TYPE;
82:
83: CURSOR cur_get_valid_dates (v_validity_rule_id NUMBER)
84: IS
85: SELECT start_date, end_date