APPS.AP_WEB_CREDIT_CARD_WF dependencies on AP_CCARD_ESC_NEXT_GT

Line 3492: DELETE FROM ap_ccard_esc_next_gt;

3488: l_debugInfo := 'Loop over all the Dunning Charges ';
3489:
3490: l_dunning_number := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'DUNNING_NUMBER');
3491:
3492: DELETE FROM ap_ccard_esc_next_gt;
3493:
3494: -- IF (NOT GetHierarchialEmployeeCursor(l_supervisor_id,l_employee_cursor)) THEN
3495: -- 5049215 -- Added the dunning number to the function level as only records of this dunning level are processed later.
3496: IF (NOT GetHierarchialEmployeeCursor(l_supervisor_id,l_employee_cursor, l_dunning_number)) THEN

Line 3545: INSERT INTO ap_ccard_esc_next_gt

3541: l_gross_outstanding := l_gross_outstanding + nvl(l_total_amt_outstanding,0);
3542: l_gross_amount := l_gross_amount + nvl(l_total_amount,0);
3543: END IF;
3544:
3545: INSERT INTO ap_ccard_esc_next_gt
3546: (aging_manager_id,
3547: employee_display_name,
3548: supervisor_display_name,
3549: direct_report_name,

Line 3673: DELETE FROM ap_ccard_esc_next_gt;

3669: l_debugInfo := 'Loop over all the Dunning Charges ';
3670:
3671: AP_WEB_EXPENSE_WF.GetManager(l_employeeId, l_supervisor_id);
3672:
3673: DELETE FROM ap_ccard_esc_next_gt;
3674:
3675: IF (NOT GetEmployeeCursor(l_supervisor_id,l_employee_cursor)) THEN
3676: NULL;
3677: END IF;

Line 3715: INSERT INTO ap_ccard_esc_next_gt

3711: l_total_amt_outstanding := nvl(l_total_amt_outstanding,0) + nvl(l_total_amt_dispute,0);
3712:
3713: l_total_num_outstanding := nvl(l_total_outstanding,0) + nvl(l_total_dispute,0);
3714:
3715: INSERT INTO ap_ccard_esc_next_gt
3716: (
3717: aging_manager_id,
3718: employee_display_name,
3719: total_num_outstanding,