APPS.PA_ACTIONS_PUB dependencies on DUAL

Line 3451: FROM DUAL;

3447: , l_attribute12_tbl(i_actn)
3448: , l_attribute13_tbl(i_actn)
3449: , l_attribute14_tbl(i_actn)
3450: , l_attribute15_tbl(i_actn)
3451: FROM DUAL;
3452: ELSE -- UPDATE
3453: SELECT
3454: decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , element_name , p_action_in_tbl(i_actn).action_name )
3455: , decode(p_action_in_tbl(i_actn).action_owner_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , manager_person_id, p_action_in_tbl(i_actn).action_owner_id )

Line 3849: FROM DUAL;

3845: , l_dlv_req_action_tbl(i_proc).ready_to_procure_flag
3846: , l_dlv_req_action_tbl(i_proc).initiate_procure_flag
3847: , l_dlv_req_action_tbl(i_proc).uom_code
3848: , l_dlv_req_action_tbl(i_proc).currency
3849: FROM DUAL;
3850:
3851: ELSE -- UPDATE
3852:
3853: SELECT l_object_version_id

Line 3970: FROM DUAL;

3966: , l_dlv_ship_action_tbl(i_ship).initiate_planning_flag
3967: , l_dlv_ship_action_tbl(i_ship).initiate_shipping_flag
3968: , l_dlv_ship_action_tbl(i_ship).uom_code
3969: , l_dlv_ship_action_tbl(i_ship).quantity
3970: FROM DUAL;
3971:
3972: ELSE -- UPDATE
3973: SELECT l_object_version_id
3974: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke