APPS.ARP_MAINTAIN_PS2 dependencies on AR_RECEIVABLE_APPLICATIONS

Line 1584: ar_receivable_applications ra,

1580: /* null, */
1581: nvl(ps.receivables_charges_remaining,0)
1582: /* , 0 */
1583: FROM
1584: ar_receivable_applications ra,
1585: ar_payment_schedules ps,
1586: ar_adjustments adj,
1587: ra_cust_trx_types ctt,
1588: ra_cust_trx_line_gl_dist ctlgd,

Line 1772: 'INSERT INTO AR_RECEIVABLE_APPLICATIONS

1768: ------------------------------------------------
1769: -- Insert ra sql
1770: ------------------------------------------------
1771: l_insert_ra_sql :=
1772: 'INSERT INTO AR_RECEIVABLE_APPLICATIONS
1773: (
1774: created_by,
1775: creation_date,
1776: last_updated_by,

Line 2489: from ar_receivable_applications

2485:
2486: CURSOR get_appl_info (p_rec_app_id NUMBER) IS
2487: SELECT payment_schedule_id,
2488: applied_payment_schedule_id
2489: from ar_receivable_applications
2490: where receivable_application_id = p_rec_app_id;
2491:
2492: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
2493:

Line 2492: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;

2488: applied_payment_schedule_id
2489: from ar_receivable_applications
2490: where receivable_application_id = p_rec_app_id;
2491:
2492: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
2493:
2494: l_ignore INTEGER;
2495:
2496: l_direction NUMBER; -- 1 for FIFO, -1 for LIFO

Line 2510: l_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%type;

2506: l_ps_class ar_payment_schedules.class%type;
2507: l_ps_is ar_payment_schedules.payment_schedule_id%type;
2508: l_ps_id ar_payment_schedules.payment_schedule_id%type;
2509:
2510: l_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%type;
2511:
2512: BEGIN
2513: print_fcn_label2('arp_maintain_ps2.process_ira_data()+' );
2514:

Line 2840: -- Insert into ar_receivable_applications

2836: MSG_LEVEL_BASIC );
2837: RAISE;
2838: END;
2839: -------------------------------------------------------------
2840: -- Insert into ar_receivable_applications
2841: -------------------------------------------------------------
2842:
2843: FOR i IN 0..p_number_records - 1 LOOP
2844:

Line 2944: select ar_receivable_applications_s.nextval

2940: dbms_sql.bind_variable( p_insert_ra_c,
2941: 'post_to_gl_flag',
2942: p_select_rec.post_to_gl_flag );
2943:
2944: select ar_receivable_applications_s.nextval
2945: into l_receivable_application_id
2946: from dual;
2947:
2948: dbms_sql.bind_variable( p_insert_ra_c,

Line 3629: ar_receivable_applications ra,

3625: ra_cust_trx_types ctt,
3626: ra_cust_trx_types ctt_com,
3627: ra_cust_trx_line_gl_dist ctlgd_com,
3628: ar_payment_schedules ps,
3629: ar_receivable_applications ra,
3630: ar_adjustments adj,
3631: fnd_currencies c,
3632: ra_terms t,
3633: ra_terms_lines tl,

Line 5206: ar_receivable_applications ra,

5202: ra_cust_trx_types ctt,
5203: ra_cust_trx_line_gl_dist ctlgd_com,
5204: ar_payment_schedules ps,
5205: ar_payment_schedules ps_inv,
5206: ar_receivable_applications ra,
5207: ar_adjustments adj,
5208: ar_adjustments adjd,
5209: fnd_currencies c,
5210: fnd_currencies c_ps,