DBA Data[Home] [Help]

APPS.PA_MASS_ASGMT_TRX dependencies on PA_MASS_TXN_ASGMT_SUCCESS_V

Line 937: FROM pa_mass_txn_asgmt_success_v

933: --be calculated.
934: IF l_mode = G_MASS_ASGMT THEN
935:
936: SELECT assignment_id INTO l_any_success_assignment_id
937: FROM pa_mass_txn_asgmt_success_v
938: WHERE item_type = p_item_type
939: AND item_key= p_item_key
940: AND ROWNUM = 1;
941:

Line 1029: FROM pa_mass_txn_asgmt_success_v pmt,

1025: -- Bug 9114634. Change of placement.
1026: if l_success_assignments > 0 THEN
1027: -- bug#9464279
1028: SELECT pmt.assignment_id BULK COLLECT INTO l_success_assignment_id_tbl2
1029: FROM pa_mass_txn_asgmt_success_v pmt,
1030: pa_project_assignments ppa
1031: WHERE pmt.item_type = p_item_type
1032: AND pmt.item_key= p_item_key
1033: and pmt.assignment_id= ppa.assignment_id