DBA Data[Home] [Help]

APPS.AZ_R12_TRANSFORM_CASCADE dependencies on AZ_STRUCTURE_APIS_B

Line 968: az_structure_apis_b f

964: INTO v_parent_api_code
965: FROM az_requests d,
966: TABLE(xmlsequence(extract(d.selection_set,
967: '/EXT/H'))) e,
968: az_structure_apis_b f
969: WHERE existsnode(VALUE(e),
970: '/H/V[@N="EntityOccuranceName" or @N="EntityOccuranceCode" or @N="RefEntityOccuranceCode"]') = 1
971: -- AND existsnode(VALUE(e),
972: -- '/H/V[@N="SelectionFlag" and .="Y"]') = 1

Line 996: az_structure_apis_b f

992: INTO v_current_api_code
993: FROM az_requests d,
994: TABLE(xmlsequence(extract(d.selection_set,
995: '/EXT/H'))) e,
996: az_structure_apis_b f
997: WHERE existsnode(VALUE(e),
998: '/H/V[@N="EntityOccuranceName" or @N="EntityOccuranceCode" or @N="RefEntityOccuranceCode"]') = 1
999: -- AND existsnode(VALUE(e),
1000: -- '/H/V[@N="SelectionFlag" and .="Y"]') = 1