APPS.ARP_CONSINV dependencies on RA_TERMS

Line 501: FROM ra_terms T,

497: CURSOR C_types (C_cutoff_day NUMBER, C_term_id NUMBER) IS
498: SELECT T.term_id term_id ,
499: TL1.due_day_of_month day_due,
500: TL1.due_months_forward months_forward
501: FROM ra_terms T,
502: ra_terms_lines TL1
503: WHERE TL1.term_id = T.term_id
504: AND T.term_id = nvl(C_term_id, T.term_id)
505: AND T.due_cutoff_day = C_cutoff_day

Line 502: ra_terms_lines TL1

498: SELECT T.term_id term_id ,
499: TL1.due_day_of_month day_due,
500: TL1.due_months_forward months_forward
501: FROM ra_terms T,
502: ra_terms_lines TL1
503: WHERE TL1.term_id = T.term_id
504: AND T.term_id = nvl(C_term_id, T.term_id)
505: AND T.due_cutoff_day = C_cutoff_day
506: AND TL1.due_day_of_month IS NOT NULL

Line 509: from ra_terms_lines TL2

505: AND T.due_cutoff_day = C_cutoff_day
506: AND TL1.due_day_of_month IS NOT NULL
507: AND TL1.due_months_forward IS NOT NULL
508: AND 1 = (select count(*)
509: from ra_terms_lines TL2
510: where TL2.term_id = TL1.term_id) ;
511:
512: /* bug2892106 Broke up this stmt into 3 stmt based on parameter.
513: -- bug2501071 : Moved ra_terms/(_lines) to c_types in order to

Line 513: -- bug2501071 : Moved ra_terms/(_lines) to c_types in order to

509: from ra_terms_lines TL2
510: where TL2.term_id = TL1.term_id) ;
511:
512: /* bug2892106 Broke up this stmt into 3 stmt based on parameter.
513: -- bug2501071 : Moved ra_terms/(_lines) to c_types in order to
514: -- fix cartesian join
515: -- bug2656229 : Added NOT EXISTS condition to prevent from data corruption
516: CURSOR C_sites (C_detail_option VARCHAR, C_customer_id NUMBER,
517: C_site_use_id NUMBER, C_cutoff_date DATE,

Line 646: /** need day of month of cut-off date to match against ra_terms. **/

642: dbms_output.put_line('P_last_day_of_month: '||P_last_day_of_month);
643: dbms_output.put_line('P_term_id : '||TO_CHAR(P_term_id));
644: */
645:
646: /** need day of month of cut-off date to match against ra_terms. **/
647: l_cutoff_day := P_cutoff_date -
648: trunc(P_cutoff_date,'MONTH') + 1;
649: /*
650: 857820: If P_last_day_of_month = 'Y' then use last day of month type terms