APPS.AP_WEB_UTILITIES_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 3372: ap_payment_schedules_all parent_aps

3368: 'Y','PAID','N','INVOICED','P','PARPAID',NULL) ) invoice_status
3369: FROM ap_expense_report_headers_all parent_aerh,
3370: ap_expense_report_headers_all main_aerh,
3371: ap_invoices_all parent_ai,
3372: ap_payment_schedules_all parent_aps
3373: WHERE
3374: main_aerh.bothpay_parent_id = parent_aerh.report_header_id (+) and
3375: parent_aerh.vouchno = parent_ai.invoice_id and
3376: parent_ai.invoice_id = parent_aps.invoice_id and

Line 3388: ap_payment_schedules_all main_aps

3384: 'Y','PAID','N','INVOICED','P','PARPAID',NULL) ) invoice_status
3385: FROM
3386: ap_expense_report_headers_all main_aerh,
3387: ap_invoices_all main_ai,
3388: ap_payment_schedules_all main_aps
3389: WHERE
3390: main_aerh.vouchno = main_ai.invoice_id and
3391: main_ai.invoice_id = main_aps.invoice_id and
3392: main_aerh.vouchno = p_invoice_id

Line 3404: ap_payment_schedules_all child_aps

3400: FROM
3401: ap_expense_report_headers_all child_aerh,
3402: ap_expense_report_headers_all main_aerh,
3403: ap_invoices_all child_ai,
3404: ap_payment_schedules_all child_aps
3405: WHERE child_aerh.bothpay_parent_id (+) = main_aerh.report_header_id and
3406: child_aerh.vouchno = child_ai.invoice_id and
3407: child_ai.invoice_id = child_aps.invoice_id and
3408: main_aerh.vouchno = p_invoice_id;

Line 3420: ap_payment_schedules_all parent_aps

3416: DECODE(p_pay_status_flag,
3417: 'Y','PAID','N','INVOICED','P','PARPAID',NULL) ) invoice_status
3418: FROM ap_expense_report_headers_all parent_aerh,
3419: ap_expense_report_headers_all main_aerh,
3420: ap_payment_schedules_all parent_aps
3421: WHERE
3422: main_aerh.bothpay_parent_id = parent_aerh.report_header_id (+) and
3423: parent_aerh.vouchno = parent_aps.invoice_id and
3424: main_aerh.vouchno = p_invoice_id

Line 3434: ap_payment_schedules_all main_aps

3430: DECODE(p_pay_status_flag,
3431: 'Y','PAID','N','INVOICED','P','PARPAID',NULL) ) invoice_status
3432: FROM
3433: ap_expense_report_headers_all main_aerh,
3434: ap_payment_schedules_all main_aps
3435: WHERE
3436: main_aerh.vouchno = main_aps.invoice_id and
3437: main_aerh.vouchno = p_invoice_id
3438: UNION

Line 3448: ap_payment_schedules_all child_aps

3444: 'Y','PAID','N','INVOICED','P','PARPAID',NULL) ) invoice_status
3445: FROM
3446: ap_expense_report_headers_all child_aerh,
3447: ap_expense_report_headers_all main_aerh,
3448: ap_payment_schedules_all child_aps
3449: WHERE child_aerh.bothpay_parent_id (+) = main_aerh.report_header_id and
3450: child_aerh.vouchno = child_aps.invoice_id and
3451: main_aerh.vouchno = p_invoice_id;
3452: