APPS.CLN_NTFYINVC_PKG dependencies on AP_INVOICE_LINES_INTERFACE

Line 23: WHERE PARENT_ID in (SELECT INVOICE_LINE_ID FROM AP_INVOICE_LINES_INTERFACE WHERE INVOICE_ID = p_invoice_id)

19:
20: CURSOR c_line_errors IS
21: SELECT PARENT_ID, REJECT_LOOKUP_CODE
22: FROM AP_INTERFACE_REJECTIONS
23: WHERE PARENT_ID in (SELECT INVOICE_LINE_ID FROM AP_INVOICE_LINES_INTERFACE WHERE INVOICE_ID = p_invoice_id)
24: AND PARENT_TABLE = 'AP_INVOICE_LINES_INTERFACE';
25:
26: BEGIN
27: IF (l_Debug_Level <= 2) THEN

Line 24: AND PARENT_TABLE = 'AP_INVOICE_LINES_INTERFACE';

20: CURSOR c_line_errors IS
21: SELECT PARENT_ID, REJECT_LOOKUP_CODE
22: FROM AP_INTERFACE_REJECTIONS
23: WHERE PARENT_ID in (SELECT INVOICE_LINE_ID FROM AP_INVOICE_LINES_INTERFACE WHERE INVOICE_ID = p_invoice_id)
24: AND PARENT_TABLE = 'AP_INVOICE_LINES_INTERFACE';
25:
26: BEGIN
27: IF (l_Debug_Level <= 2) THEN
28: cln_debug_pub.Add('------ Entering CLN_NTFYINVC_PKG.GET_AR_REJECTIONS_STRING API ------ ', 2);

Line 48: WHERE parent_table = 'AP_INVOICE_LINES_INTERFACE'

44: AND parent_id = p_invoice_id
45: UNION ALL
46: SELECT 'x'
47: FROM ap_interface_rejections air
48: WHERE parent_table = 'AP_INVOICE_LINES_INTERFACE'
49: AND parent_id in (select invoice_line_id from ap_invoice_lines_interface aili
50: where aili.invoice_id = p_invoice_id)
51: );
52: EXCEPTION

Line 49: AND parent_id in (select invoice_line_id from ap_invoice_lines_interface aili

45: UNION ALL
46: SELECT 'x'
47: FROM ap_interface_rejections air
48: WHERE parent_table = 'AP_INVOICE_LINES_INTERFACE'
49: AND parent_id in (select invoice_line_id from ap_invoice_lines_interface aili
50: where aili.invoice_id = p_invoice_id)
51: );
52: EXCEPTION
53: WHEN NO_DATA_FOUND THEN

Line 1763: WHERE PARENT_ID in (SELECT INVOICE_LINE_ID FROM AP_INVOICE_LINES_INTERFACE WHERE INVOICE_ID = p_invoice_id)

1759:
1760: CURSOR c_line_errors IS
1761: SELECT PARENT_ID, REJECT_LOOKUP_CODE
1762: FROM AP_INTERFACE_REJECTIONS
1763: WHERE PARENT_ID in (SELECT INVOICE_LINE_ID FROM AP_INVOICE_LINES_INTERFACE WHERE INVOICE_ID = p_invoice_id)
1764: AND PARENT_TABLE = 'AP_INVOICE_LINES_INTERFACE';
1765:
1766: BEGIN
1767:

Line 1764: AND PARENT_TABLE = 'AP_INVOICE_LINES_INTERFACE';

1760: CURSOR c_line_errors IS
1761: SELECT PARENT_ID, REJECT_LOOKUP_CODE
1762: FROM AP_INTERFACE_REJECTIONS
1763: WHERE PARENT_ID in (SELECT INVOICE_LINE_ID FROM AP_INVOICE_LINES_INTERFACE WHERE INVOICE_ID = p_invoice_id)
1764: AND PARENT_TABLE = 'AP_INVOICE_LINES_INTERFACE';
1765:
1766: BEGIN
1767:
1768: IF (l_Debug_Level <= 2) THEN