APPS.ARP_MAINTAIN_PS2 dependencies on AR_RECEIVABLE_APPLICATIONS

Line 1576: ar_receivable_applications ra,

1572: /* null, */
1573: nvl(ps.receivables_charges_remaining,0)
1574: /* , 0 */
1575: FROM
1576: ar_receivable_applications ra,
1577: ar_payment_schedules ps,
1578: ar_adjustments adj,
1579: ra_cust_trx_types ctt,
1580: ra_cust_trx_line_gl_dist ctlgd,

Line 1764: 'INSERT INTO AR_RECEIVABLE_APPLICATIONS

1760: ------------------------------------------------
1761: -- Insert ra sql
1762: ------------------------------------------------
1763: l_insert_ra_sql :=
1764: 'INSERT INTO AR_RECEIVABLE_APPLICATIONS
1765: (
1766: created_by,
1767: creation_date,
1768: last_updated_by,

Line 2481: from ar_receivable_applications

2477:
2478: CURSOR get_appl_info (p_rec_app_id NUMBER) IS
2479: SELECT payment_schedule_id,
2480: applied_payment_schedule_id
2481: from ar_receivable_applications
2482: where receivable_application_id = p_rec_app_id;
2483:
2484: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
2485:

Line 2484: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;

2480: applied_payment_schedule_id
2481: from ar_receivable_applications
2482: where receivable_application_id = p_rec_app_id;
2483:
2484: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
2485:
2486: l_ignore INTEGER;
2487:
2488: l_direction NUMBER; -- 1 for FIFO, -1 for LIFO

Line 2502: l_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%type;

2498: l_ps_class ar_payment_schedules.class%type;
2499: l_ps_is ar_payment_schedules.payment_schedule_id%type;
2500: l_ps_id ar_payment_schedules.payment_schedule_id%type;
2501:
2502: l_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%type;
2503:
2504: BEGIN
2505: print_fcn_label2('arp_maintain_ps2.process_ira_data()+' );
2506:

Line 2832: -- Insert into ar_receivable_applications

2828: MSG_LEVEL_BASIC );
2829: RAISE;
2830: END;
2831: -------------------------------------------------------------
2832: -- Insert into ar_receivable_applications
2833: -------------------------------------------------------------
2834:
2835: FOR i IN 0..p_number_records - 1 LOOP
2836:

Line 2936: select ar_receivable_applications_s.nextval

2932: dbms_sql.bind_variable( p_insert_ra_c,
2933: 'post_to_gl_flag',
2934: p_select_rec.post_to_gl_flag );
2935:
2936: select ar_receivable_applications_s.nextval
2937: into l_receivable_application_id
2938: from dual;
2939:
2940: dbms_sql.bind_variable( p_insert_ra_c,

Line 3621: ar_receivable_applications ra,

3617: ra_cust_trx_types ctt,
3618: ra_cust_trx_types ctt_com,
3619: ra_cust_trx_line_gl_dist ctlgd_com,
3620: ar_payment_schedules ps,
3621: ar_receivable_applications ra,
3622: ar_adjustments adj,
3623: fnd_currencies c,
3624: ra_terms t,
3625: ra_terms_lines tl,

Line 5197: ar_receivable_applications ra,

5193: ra_cust_trx_types ctt,
5194: ra_cust_trx_line_gl_dist ctlgd_com,
5195: ar_payment_schedules ps,
5196: ar_payment_schedules ps_inv,
5197: ar_receivable_applications ra,
5198: ar_adjustments adj,
5199: ar_adjustments adjd,
5200: fnd_currencies c,
5201: fnd_currencies c_ps,