APPS.GMF_AP_INVOICE_CHECKS_INFO dependencies on AP_LOOKUP_CODES

Line 71: from ap_lookup_codes

67: void_date;
68:
69:
70: select displayed_field into checkstatus
71: from ap_lookup_codes
72: where lookup_type = 'CHECK STATE'
73: and lookup_code = wcheck_status;
74:
75: if void_date is not null then

Line 77: from ap_lookup_codes

73: and lookup_code = wcheck_status;
74:
75: if void_date is not null then
76: select displayed_field into status
77: from ap_lookup_codes
78: where lookup_type = 'CHECK STATE'
79: and lookup_code = 'VOID';
80: elsif t_stopped_at is null then
81: status := NULL;

Line 84: from ap_lookup_codes

80: elsif t_stopped_at is null then
81: status := NULL;
82: elsif t_released_at is null and t_stopped_at is not null then
83: select displayed_field into status
84: from ap_lookup_codes
85: where lookup_type = 'STOP PAYMENT STATUS'
86: and lookup_code = 'STOPPED';
87: else
88: select displayed_field into status

Line 89: from ap_lookup_codes

85: where lookup_type = 'STOP PAYMENT STATUS'
86: and lookup_code = 'STOPPED';
87: else
88: select displayed_field into status
89: from ap_lookup_codes
90: where lookup_type = 'STOP PAYMENT STATUS'
91: and lookup_code = 'RELEASED';
92: end if;
93: