DBA Data[Home] [Help]

APPS.GHR_SF52_DO_UPDATE dependencies on PER_PAY_PROPOSALS

Line 4913: from per_pay_proposals ppp

4909: Cursor Cur_proposal_exists (p_assignment_id IN NUMBER,
4910: p_eff_date IN DATE) is
4911: Select ppp.pay_proposal_id proposal_id,
4912: ppp.object_version_number ovn
4913: from per_pay_proposals ppp
4914: where ppp.assignment_id = p_assignment_id
4915: and change_date = p_eff_date;
4916:
4917: l_proposal_id NUMBER;