APPS.JAI_PO_HOOK_PKG dependencies on DUAL

Line 1015: SELECT JAI_CMN_LINES_S.NEXTVAL INTO ln_cmn_line_id FROM DUAL;

1011:
1012: FOR r_txns IN c_txns_interface(p_hdr_intf_id)
1013: LOOP
1014: /*ln_cmn_line_id := JAI_CMN_LINES_S.nextval;*/
1015: SELECT JAI_CMN_LINES_S.NEXTVAL INTO ln_cmn_line_id FROM DUAL;
1016:
1017: OPEN c_po_line_loc_details(r_txns.po_line_location_id);
1018: FETCH c_po_line_loc_details
1019: INTO r_line_locations;

Line 1684: SELECT fnd_profile.VALUE(cp_profile_name) FROM DUAL;

1680: END gettax;
1681:
1682: FUNCTION get_profile_value(cp_profile_name VARCHAR2) RETURN VARCHAR2 IS
1683: CURSOR c_iproc_profile IS
1684: SELECT fnd_profile.VALUE(cp_profile_name) FROM DUAL;
1685:
1686: lv_iproc_profile VARCHAR2(100);
1687:
1688: BEGIN