DBA Data[Home] [Help]

APPS.ARP_MAINTAIN_PS2 dependencies on DUAL

Line 1065: FROM dual;

1061: MRC trigger replacement */
1062:
1063: SELECT ar_payment_schedules_s.nextval
1064: INTO l_ps_id
1065: FROM dual;
1066:
1067: dbms_sql.bind_variable( p_insert_ps_c,
1068: 'payment_schedule_id',
1069: l_ps_id );

Line 2709: FROM dual;

2705:
2706: /* added for mrc trigger elimination */
2707: SELECT ar_payment_schedules_s.nextval
2708: INTO l_ps_id
2709: FROM dual;
2710:
2711: dbms_sql.bind_variable( p_insert_ps_c,
2712: 'payment_schedule_id',
2713: l_ps_id );

Line 2938: from dual;

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,
2941: 'receivable_application_id',
2942: l_receivable_application_id );

Line 4468: FROM dual;

4464:
4465: /* VAT changes */
4466: SELECT ar_adjustments_s.nextval
4467: INTO l_adjustment_id
4468: FROM dual;
4469:
4470: dbms_sql.bind_variable( p_insert_adj_c,
4471: 'adjustment_id',
4472: l_adjustment_id );

Line 6298: FROM dual;

6294:
6295: /* VAT changes */
6296: SELECT ar_adjustments_s.nextval
6297: INTO l_adjustment_id
6298: FROM dual;
6299:
6300: dbms_sql.bind_variable( p_insert_adj_c,
6301: 'adjustment_id',
6302: l_adjustment_id );