DBA Data[Home] [Help]

APPS.FUN_OPEN_INTERFACE_PKG dependencies on DUAL

Line 522: FROM dual)

518: fnd_user u,
519: per_all_people_f pap,
520: (SELECT fnd_global.user_id() AS
521: user_id
522: FROM dual)
523: curr
524: WHERE curr.user_id = u.user_id
525: AND u.employee_id = pap.person_id
526: AND pap.party_id = hzp.party_id

Line 634: FROM dual;

630:
631: IF l_numbering_type = 'SYS' then
632: /* SELECT FUN_SEQ_S1.nextval
633: INTO l_batch_num
634: FROM dual;
635: */
636: l_control_date_tbl := fun_seq.control_date_tbl_type();
637: l_control_date_tbl.extend(1);
638: l_control_date_tbl(1).date_type := 'CREATION_DATE';

Line 1245: FROM dual)

1241: fnd_user u,
1242: per_all_people_f pap,
1243: (SELECT fnd_global.user_id() AS
1244: user_id
1245: FROM dual)
1246: curr
1247: WHERE curr.user_id = u.user_id
1248: AND u.employee_id = pap.person_id
1249: AND pap.party_id = hzp.party_id