APPS.IGS_PE_USERID_PKG dependencies on DUAL

Line 1447: FROM DUAL;

1443: l_default_date DATE := TRUNC(SYSDATE);
1444:
1445: CURSOR c_dt_format(cp_date VARCHAR2) IS
1446: SELECT fnd_date.canonical_to_date(cp_date)
1447: FROM DUAL;
1448:
1449: l_object_version_number NUMBER;
1450: l_contact_point_ovn NUMBER;
1451:

Line 1787: FROM DUAL;

1783: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
1784:
1785: CURSOR c_seq_num IS
1786: SELECT IGS_PE_GEN_USER_S.nextval
1787: FROM DUAL;
1788:
1789: ln_seq_val NUMBER;
1790:
1791: BEGIN

Line 1955: FROM DUAL;

1951: WHERE preferred_ind ='Y';
1952:
1953: CURSOR c_seq_num IS
1954: SELECT IGS_PE_GEN_USER_S.nextval
1955: FROM DUAL;
1956:
1957: lv_UniqueInd igs_pe_person_id_typ.UNIQUE_IND%TYPE;
1958: l_person_number hz_parties.party_number%TYPE;
1959:

Line 2075: FROM DUAL;

2071: ) AS
2072:
2073: CURSOR c_seq_num IS
2074: SELECT IGS_PE_GEN_USER_S.nextval
2075: FROM DUAL;
2076:
2077: ln_seq_val NUMBER;
2078: l_event_t wf_event_t;
2079: l_parameter_list_t wf_parameter_list_t;