APPS.AR_BFB_UTILS_PVT dependencies on AR_CONS_BILL_CYCLE_DATES

Line 58: ar_cons_bill_cycle_dates cyd

54: --Modified the logic to pick start_date when billing_date passed is less than start_date
55: select min(trunc(billable_date))
56: into l_billing_date
57: from ar_cons_bill_cycles_b cy,
58: ar_cons_bill_cycle_dates cyd
59: where cy.billing_cycle_id = p_billing_cycle_id
60: and cy.billing_cycle_id = cyd.billing_cycle_id
61: and cyd.billable_date
62: between trunc(greatest(nvl(p_billing_date,sysdate), nvl(cy.START_DATE, sysdate)))

Line 91: from ar_cons_bill_cycle_dates

87:
88: if p_billing_date > nvl(p_last_bill_date, sysdate) then
89: select max(billable_date)
90: into l_billing_date
91: from ar_cons_bill_cycle_dates
92: where billing_cycle_id = p_billing_cycle_id
93: and billable_date between trunc(p_last_bill_date) and trunc(p_billing_date);
94: else
95: select max(billable_date)

Line 97: from ar_cons_bill_cycle_dates

93: and billable_date between trunc(p_last_bill_date) and trunc(p_billing_date);
94: else
95: select max(billable_date)
96: into l_billing_date
97: from ar_cons_bill_cycle_dates
98: where billing_cycle_id = p_billing_cycle_id
99: and billable_date between trunc(p_billing_date) and trunc(p_last_bill_date);
100: end if;
101:

Line 661: INSERT INTO AR_CONS_BILL_CYCLE_DATES (

657:
658: --------------------------------------------------------
659: --Insert the Bill Date in the table
660: --------------------------------------------------------
661: INSERT INTO AR_CONS_BILL_CYCLE_DATES (
662: BILLING_CYCLE_ID ,
663: BILLABLE_DATE ,
664: CREATED_BY ,
665: CREATION_DATE ,

Line 721: INSERT INTO AR_CONS_BILL_CYCLE_DATES (

717:
718: --------------------------------------------------------
719: --Insert the Bill Date in the table
720: --------------------------------------------------------
721: INSERT INTO AR_CONS_BILL_CYCLE_DATES (
722: BILLING_CYCLE_ID ,
723: BILLABLE_DATE ,
724: CREATED_BY ,
725: CREATION_DATE ,

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

838: to_date(l_char_date1,'DD/MM/RRRR');
839: end if;
840: /* Changes for Bug 7365237: - Start
841: Fix for the Bug 7365237 will ensure that duplicate values (combination of billing_cycle_id and billable_date)
842: would not be inserted in the table AR_CONS_BILL_CYCLE_DATES */
843: if l_day_type = 'W' and ar_day_of_week(l_next_billing_date) in (6,7) then
844: if ar_day_of_week(l_next_billing_date) = 6 then
845: -- If the billable day is 'Saturday', make the coming monday as billable day and skip Saturday.
846: daytab(i+2) := 'Y';

Line 855: INSERT INTO AR_CONS_BILL_CYCLE_DATES (

851: else -- if the day_type is not 'W' or if the day is not a Weekend (Saturday or Sunday)
852: --------------------------------------------------------
853: --Insert the Bill Date in the table
854: --------------------------------------------------------
855: INSERT INTO AR_CONS_BILL_CYCLE_DATES (
856: BILLING_CYCLE_ID ,
857: BILLABLE_DATE ,
858: CREATED_BY ,
859: CREATION_DATE ,