DBA Data[Home] [Help]

APPS.PER_GB_PENSRV_SVPN dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 330: FROM pqp_assignment_attributes_f

326: -- check to find if the contract type is ever attached to this person's assignment
327: CURSOR csr_chk_asg_contract_exist( p_assignment_id IN NUMBER)
328: IS
329: SELECT 1
330: FROM pqp_assignment_attributes_f
331: WHERE assignment_id = p_assignment_id
332: AND contract_type is NOT NULL
333: AND rownum < 2;
334: