APPS.ARP_DATES dependencies on RA_CUSTOMER_TRX_LINES

Line 439: ra_customer_trx_lines.accounting_rule_duration%type,

435: PROCEDURE val_gl_periods_for_rules(
436: p_request_id IN ra_customer_trx.request_id%type,
437: p_acc_rule_id IN ra_rules.rule_id%type,
438: p_acc_duration IN
439: ra_customer_trx_lines.accounting_rule_duration%type,
440: p_rule_start_date IN
441: ra_customer_trx_lines.rule_start_date%type,
442: p_sob_id IN
443: gl_sets_of_books.set_of_books_id%type ) IS

Line 441: ra_customer_trx_lines.rule_start_date%type,

437: p_acc_rule_id IN ra_rules.rule_id%type,
438: p_acc_duration IN
439: ra_customer_trx_lines.accounting_rule_duration%type,
440: p_rule_start_date IN
441: ra_customer_trx_lines.rule_start_date%type,
442: p_sob_id IN
443: gl_sets_of_books.set_of_books_id%type ) IS
444: l_ai_flag boolean;
445: l_count integer;

Line 688: FROM ra_customer_trx_lines rl

684: arp_global.MSG_LEVEL_DEBUG);
685:
686: SELECT MIN(rl.rule_start_date)
687: INTO p_candidate_date
688: FROM ra_customer_trx_lines rl
689: WHERE rl.customer_trx_id = p_customer_trx_id
690: AND line_type = 'LINE';
691:
692: ELSE

Line 700: FROM ra_customer_trx_lines ctl,

696: /*Bug 2505767, Added an additional check in the where clause to pick up only
697: those periods which match with the type defined in the set of books*/
698: SELECT COUNT(gp1.period_set_name)
699: INTO actual_num_fiscal_year
700: FROM ra_customer_trx_lines ctl,
701: gl_sets_of_books b,
702: gl_periods gp1
703: WHERE ctl.customer_trx_id = p_customer_trx_id
704: AND ctl.set_of_books_id = b.set_of_books_id

Line 724: FROM ra_customer_trx_lines ctl,

720: )
721: )
722: )
723: INTO p_candidate_date
724: FROM ra_customer_trx_lines ctl,
725: gl_periods gp1,
726: gl_periods gp2,
727: gl_sets_of_books b,
728: gl_period_types t,