DBA Data[Home] [Help]

APPS.PQH_SS_WORKFLOW dependencies on PER_ASSIGNMENTS_F

Line 1144: per_assignments_f af

1140: --
1141: CURSOR cur_match_ovn (c_txn_step_id NUMBER, c_effDate DATE) IS
1142: SELECT 'X'
1143: FROM hr_api_transaction_values tv,
1144: per_assignments_f af
1145: WHERE af.assignment_id = p_assignmentId
1146: AND tv.transaction_step_id = c_txn_step_id
1147: AND tv.name = 'P_OBJECT_VERSION_NUMBER'
1148: AND c_effDate BETWEEN af.effective_start_date AND af.effective_end_date