APPS.AR_BFB_UTILS_PVT dependencies on AR_CONS_BILL_CYCLES_B

Line 57: from ar_cons_bill_cycles_b cy,

53: -- passed in p_billing_date is a valid date, use it
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

Line 300: from ar_cons_bill_cycles_b

296: BEGIN
297:
298: select bill_cycle_type
299: into cycle_type
300: from ar_cons_bill_cycles_b
301: where billing_cycle_id = p_bill_cycle_id;
302:
303: return cycle_type;
304: EXCEPTION

Line 623: from ar_cons_bill_cycles_b

619: day_type,
620: trunc(start_date)
621: into l_cycle_frequency ,
622: l_repeat_frequency , l_skip_weekends, l_day_type,l_start_date
623: from ar_cons_bill_cycles_b
624: where billing_cycle_id = p_billing_cycle_id;
625:
626:
627: ------------------------------------------------

Line 694: from AR_CONS_BILL_CYCLES_B

690: l_current_date := l_start_date;
691:
692: select day_monday, day_tuesday, day_wednesday, day_thursday, day_friday, day_saturday, day_sunday
693: into week_tab(2), week_tab(3), week_tab(4), week_tab(5), week_tab(6),week_tab(7),week_tab(1)
694: from AR_CONS_BILL_CYCLES_B
695: where billing_cycle_id = p_billing_cycle_id;
696:
697: k := to_char(l_current_date,'D'); -- This variable is used to index for the start date of the Billing Cycle
698: -- k=1 indicates 'Sunday' and k=7 indicates 'Saturday'

Line 817: from ar_cons_bill_cycles_b

813: daytab(16), daytab(17), daytab(18), daytab(19), daytab(20),
814: daytab(21), daytab(22), daytab(23), daytab(24), daytab(25),
815: daytab(26), daytab(27), daytab(28), daytab(29), daytab(30), daytab(31),
816: l_last_day
817: from ar_cons_bill_cycles_b
818: where billing_cycle_id = p_billing_cycle_id;
819:
820: if l_last_day = 'Y' THEN
821: daytab(31) := 'Y';