APPS.PER_MANAGE_CONTRACTS_PKG dependencies on PER_CONTRACTS_F

Line 15: ,per_contracts_f con

11: (p_person_id IN NUMBER) RETURN VARCHAR2 IS
12: CURSOR cContract(p_person_id NUMBER) IS
13: SELECT 'Y'
14: FROM per_people_f per
15: ,per_contracts_f con
16: ,fnd_sessions ses
17: WHERE per.person_id = p_person_id
18: AND con.person_id = per.person_id
19: AND ses.session_id = USERENV('sessionid')

Line 86: FROM per_contracts_f

82: person_id,
83: reference,
84: type,
85: status
86: FROM per_contracts_f
87: WHERE contract_id = p_contract_id;
88: --
89: CURSOR c_exc_con IS
90: SELECT contract_id,

Line 97: FROM per_contracts_f

93: person_id,
94: reference,
95: type,
96: status
97: FROM per_contracts_f
98: WHERE contract_id = p_contract_id
99: AND object_version_number <> p_object_version_number;
100: --
101: l_con c_all_con%ROWTYPE;