DBA Data[Home] [Help]

APPS.CN_COLLECTION_AIA_PUB dependencies on CN_COMM_LINES_API_ALL

Line 1902: FROM cn_comm_lines_api_all

1898: IS
1899: CURSOR c_get_comm_line_id
1900: IS
1901: SELECT max(comm_lines_api_id)
1902: FROM cn_comm_lines_api_all
1903: WHERE invoice_number = p_invoice_number
1904: AND employee_number = l_employee_number
1905: AND NVL(adjust_status,'N') <> 'FROZEN';
1906:

Line 1926: FROM cn_comm_lines_api_all

1922: IS
1923: CURSOR c_get_comm_line_id
1924: IS
1925: SELECT comm_lines_api_id
1926: FROM cn_comm_lines_api_all
1927: WHERE order_number = p_order_number
1928: AND employee_number = l_employee_number
1929: AND NVL(adjust_status,'N') <> 'FROZEN';
1930: