DBA Data[Home] [Help]

APPS.GHR_SF52_DO_UPDATE dependencies on PER_PAY_PROPOSALS

Line 5172: from per_pay_proposals ppp

5168: Cursor Cur_proposal_exists (p_assignment_id IN NUMBER,
5169: p_eff_date IN DATE) is
5170: Select ppp.pay_proposal_id proposal_id,
5171: ppp.object_version_number ovn
5172: from per_pay_proposals ppp
5173: where ppp.assignment_id = p_assignment_id
5174: and change_date = p_eff_date;
5175:
5176: l_proposal_id NUMBER;