DBA Data[Home] [Help]

APPS.PQH_SS_WORKFLOW dependencies on PER_ASSIGNMENTS_F

Line 1123: per_assignments_f af

1119: --
1120: CURSOR cur_match_ovn (c_txn_step_id NUMBER, c_effDate DATE) IS
1121: SELECT 'X'
1122: FROM hr_api_transaction_values tv,
1123: per_assignments_f af
1124: WHERE af.assignment_id = p_assignmentId
1125: AND tv.transaction_step_id = c_txn_step_id
1126: AND tv.name = 'P_OBJECT_VERSION_NUMBER'
1127: AND c_effDate BETWEEN af.effective_start_date AND af.effective_end_date