APPS.AR_BFB_UTILS_PVT dependencies on AR_CONS_BILL_CYCLE_DATES

Line 50: ar_cons_bill_cycle_dates cyd

46: --Modified the logic to pick start_date when billing_date passed is less than start_date
47: select min(trunc(billable_date))
48: into l_billing_date
49: from ar_cons_bill_cycles_b cy,
50: ar_cons_bill_cycle_dates cyd
51: where cy.billing_cycle_id = p_billing_cycle_id
52: and cy.billing_cycle_id = cyd.billing_cycle_id
53: and cyd.billable_date
54: between trunc(greatest(nvl(p_billing_date,sysdate), nvl(cy.START_DATE, sysdate)))

Line 83: from ar_cons_bill_cycle_dates

79:
80: if p_billing_date > nvl(p_last_bill_date, sysdate) then
81: select max(billable_date)
82: into l_billing_date
83: from ar_cons_bill_cycle_dates
84: where billing_cycle_id = p_billing_cycle_id
85: and billable_date between trunc(p_last_bill_date) and trunc(p_billing_date);
86: else
87: select max(billable_date)

Line 89: from ar_cons_bill_cycle_dates

85: and billable_date between trunc(p_last_bill_date) and trunc(p_billing_date);
86: else
87: select max(billable_date)
88: into l_billing_date
89: from ar_cons_bill_cycle_dates
90: where billing_cycle_id = p_billing_cycle_id
91: and billable_date between trunc(p_billing_date) and trunc(p_last_bill_date);
92: end if;
93:

Line 566: INSERT INTO AR_CONS_BILL_CYCLE_DATES (

562:
563: --------------------------------------------------------
564: --Insert the Bill Date in the table
565: --------------------------------------------------------
566: INSERT INTO AR_CONS_BILL_CYCLE_DATES (
567: BILLING_CYCLE_ID ,
568: BILLABLE_DATE ,
569: CREATED_BY ,
570: CREATION_DATE ,

Line 621: INSERT INTO AR_CONS_BILL_CYCLE_DATES (

617:
618: --------------------------------------------------------
619: --Insert the Bill Date in the table
620: --------------------------------------------------------
621: INSERT INTO AR_CONS_BILL_CYCLE_DATES (
622: BILLING_CYCLE_ID ,
623: BILLABLE_DATE ,
624: CREATED_BY ,
625: CREATION_DATE ,

Line 737: would not be inserted in the table AR_CONS_BILL_CYCLE_DATES */

733: to_date(l_char_date1,'DD/MM/RRRR');
734: end if;
735: /* Changes for Bug 7365237: - Start
736: Fix for the Bug 7365237 will ensure that duplicate values (combination of billing_cycle_id and billable_date)
737: would not be inserted in the table AR_CONS_BILL_CYCLE_DATES */
738: if l_day_type = 'W' and ar_day_of_week(l_next_billing_date) in (6,7) then
739: if ar_day_of_week(l_next_billing_date) = 6 then
740: -- If the billable day is 'Saturday', make the coming monday as billable day and skip Saturday.
741: daytab(i+2) := 'Y';

Line 750: INSERT INTO AR_CONS_BILL_CYCLE_DATES (

746: else -- if the day_type is not 'W' or if the day is not a Weekend (Saturday or Sunday)
747: --------------------------------------------------------
748: --Insert the Bill Date in the table
749: --------------------------------------------------------
750: INSERT INTO AR_CONS_BILL_CYCLE_DATES (
751: BILLING_CYCLE_ID ,
752: BILLABLE_DATE ,
753: CREATED_BY ,
754: CREATION_DATE ,