APPS.AR_BFB_UTILS_PVT dependencies on AR_CONS_BILL_CYCLES_B

Line 49: from ar_cons_bill_cycles_b cy,

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

Line 232: from ar_cons_bill_cycles_b

228: BEGIN
229:
230: select bill_cycle_type
231: into cycle_type
232: from ar_cons_bill_cycles_b
233: where billing_cycle_id = p_bill_cycle_id;
234:
235: return cycle_type;
236: EXCEPTION

Line 528: from ar_cons_bill_cycles_b

524: day_type,
525: trunc(start_date)
526: into l_cycle_frequency ,
527: l_repeat_frequency , l_skip_weekends, l_day_type,l_start_date
528: from ar_cons_bill_cycles_b
529: where billing_cycle_id = p_billing_cycle_id;
530:
531:
532: ------------------------------------------------

Line 599: from AR_CONS_BILL_CYCLES_B

595: l_current_date := l_start_date;
596:
597: select day_monday, day_tuesday, day_wednesday, day_thursday, day_friday, day_saturday, day_sunday
598: into week_tab(2), week_tab(3), week_tab(4), week_tab(5), week_tab(6),week_tab(7),week_tab(1)
599: from AR_CONS_BILL_CYCLES_B
600: where billing_cycle_id = p_billing_cycle_id;
601:
602: k := to_char(l_current_date,'D'); -- This variable is used to index for the start date of the Billing Cycle
603: -- k=1 indicates 'Sunday' and k=7 indicates 'Saturday'

Line 712: from ar_cons_bill_cycles_b

708: daytab(16), daytab(17), daytab(18), daytab(19), daytab(20),
709: daytab(21), daytab(22), daytab(23), daytab(24), daytab(25),
710: daytab(26), daytab(27), daytab(28), daytab(29), daytab(30), daytab(31),
711: l_last_day
712: from ar_cons_bill_cycles_b
713: where billing_cycle_id = p_billing_cycle_id;
714:
715: if l_last_day = 'Y' THEN
716: daytab(31) := 'Y';