APPS.AP_WEB_CREDIT_CARD_WF dependencies on AP_CCARD_ESC_NEXT_GT

Line 3565: DELETE FROM ap_ccard_esc_next_gt;

3561: l_debugInfo := 'Loop over all the Dunning Charges ';
3562:
3563: l_dunning_number := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'DUNNING_NUMBER');
3564:
3565: DELETE FROM ap_ccard_esc_next_gt;
3566:
3567: -- IF (NOT GetHierarchialEmployeeCursor(l_supervisor_id,l_employee_cursor)) THEN
3568: -- 5049215 -- Added the dunning number to the function level as only records of this dunning level are processed later.
3569: IF (NOT GetHierarchialEmployeeCursor(l_supervisor_id,l_employee_cursor, l_dunning_number)) THEN

Line 3614: INSERT INTO ap_ccard_esc_next_gt

3610: l_gross_outstanding := l_gross_outstanding + nvl(l_total_amt_outstanding,0);
3611: l_gross_amount := l_gross_amount + nvl(l_total_amount,0);
3612: END IF;
3613:
3614: INSERT INTO ap_ccard_esc_next_gt
3615: (aging_manager_id,
3616: employee_display_name,
3617: supervisor_display_name,
3618: direct_report_name,

Line 3742: DELETE FROM ap_ccard_esc_next_gt;

3738: l_debugInfo := 'Loop over all the Dunning Charges ';
3739:
3740: AP_WEB_EXPENSE_WF.GetManager(l_employeeId, l_supervisor_id);
3741:
3742: DELETE FROM ap_ccard_esc_next_gt;
3743:
3744: IF (NOT GetEmployeeCursor(l_supervisor_id,l_employee_cursor)) THEN
3745: NULL;
3746: END IF;

Line 3784: INSERT INTO ap_ccard_esc_next_gt

3780: l_total_amt_outstanding := nvl(l_total_amt_outstanding,0) + nvl(l_total_amt_dispute,0);
3781:
3782: l_total_num_outstanding := nvl(l_total_outstanding,0) + nvl(l_total_dispute,0);
3783:
3784: INSERT INTO ap_ccard_esc_next_gt
3785: (
3786: aging_manager_id,
3787: employee_display_name,
3788: total_num_outstanding,