DBA Data[Home] [Help]

APPS.ARP_MAINTAIN_PS2 dependencies on DUAL

Line 1073: FROM dual;

1069: MRC trigger replacement */
1070:
1071: SELECT ar_payment_schedules_s.nextval
1072: INTO l_ps_id
1073: FROM dual;
1074:
1075: dbms_sql.bind_variable( p_insert_ps_c,
1076: 'payment_schedule_id',
1077: l_ps_id );

Line 2717: FROM dual;

2713:
2714: /* added for mrc trigger elimination */
2715: SELECT ar_payment_schedules_s.nextval
2716: INTO l_ps_id
2717: FROM dual;
2718:
2719: dbms_sql.bind_variable( p_insert_ps_c,
2720: 'payment_schedule_id',
2721: l_ps_id );

Line 2946: from dual;

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,
2949: 'receivable_application_id',
2950: l_receivable_application_id );

Line 4477: FROM dual;

4473:
4474: /* VAT changes */
4475: SELECT ar_adjustments_s.nextval
4476: INTO l_adjustment_id
4477: FROM dual;
4478:
4479: dbms_sql.bind_variable( p_insert_adj_c,
4480: 'adjustment_id',
4481: l_adjustment_id );

Line 6307: FROM dual;

6303:
6304: /* VAT changes */
6305: SELECT ar_adjustments_s.nextval
6306: INTO l_adjustment_id
6307: FROM dual;
6308:
6309: dbms_sql.bind_variable( p_insert_adj_c,
6310: 'adjustment_id',
6311: l_adjustment_id );