APPS.PA_ACTIONS_PUB dependencies on DUAL

Line 3450: FROM DUAL;

3446: , l_attribute12_tbl(i_actn)
3447: , l_attribute13_tbl(i_actn)
3448: , l_attribute14_tbl(i_actn)
3449: , l_attribute15_tbl(i_actn)
3450: FROM DUAL;
3451: ELSE -- UPDATE
3452: SELECT
3453: 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 )
3454: , 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 3840: FROM DUAL;

3836: , l_dlv_req_action_tbl(i_proc).ready_to_procure_flag
3837: , l_dlv_req_action_tbl(i_proc).initiate_procure_flag
3838: , l_dlv_req_action_tbl(i_proc).uom_code
3839: , l_dlv_req_action_tbl(i_proc).currency
3840: FROM DUAL;
3841:
3842: ELSE -- UPDATE
3843:
3844: SELECT l_object_version_id

Line 3956: FROM DUAL;

3952: , l_dlv_ship_action_tbl(i_ship).initiate_planning_flag
3953: , l_dlv_ship_action_tbl(i_ship).initiate_shipping_flag
3954: , l_dlv_ship_action_tbl(i_ship).uom_code
3955: , l_dlv_ship_action_tbl(i_ship).quantity
3956: FROM DUAL;
3957:
3958: ELSE -- UPDATE
3959: SELECT l_object_version_id
3960: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke