APPS.HRI_OLTP_DISC_TRAINING dependencies on OTA_FINANCE_LINES

Line 435: FROM ota_finance_lines

431: CURSOR finance_lines_csr( p_delegate_booking_id NUMBER ) is
432: SELECT
433: currency_code
434: ,SUM(NVL(money_amount,0)) amount
435: FROM ota_finance_lines
436: WHERE line_type = 'E' -- Enrollment
437: AND cancelled_flag = 'N'
438: AND booking_id = p_delegate_booking_id
439: GROUP BY currency_code;

Line 578: FROM ota_finance_lines

574: CURSOR finance_lines_csr(p_delegate_booking_id NUMBER) IS
575: SELECT
576: currency_code
577: ,sum(nvl(money_amount,0)) amount
578: FROM ota_finance_lines
579: WHERE line_type = 'E' -- Enrollment
580: AND cancelled_flag = 'N'
581: AND booking_id = p_delegate_booking_id
582: GROUP BY currency_code;

Line 725: FROM ota_finance_lines

721: CURSOR finance_lines_csr(p_delegate_booking_id NUMBER) IS
722: SELECT
723: currency_code
724: ,SUM(NVL(money_amount,0)) amount
725: FROM ota_finance_lines
726: WHERE line_type = 'E' -- Enrollment
727: AND cancelled_flag = 'N'
728: AND booking_id = p_delegate_booking_id
729: GROUP BY currency_code;