DBA Data[Home] [Help]

APPS.OKC_RENEW_PVT dependencies on OKC_CLASS_OPERATIONS

Line 3675: FROM okc_operation_lines a,okc_operation_instances b, okc_class_operations c

3671: FUNCTION is_already_not_renewed(p_chr_id IN NUMBER, p_contract_number IN VARCHAR2, x_msg_name OUT NOCOPY VARCHAR2, p_renewal_called_from_ui IN VARCHAR2) RETURN VARCHAR2 IS
3672: Cursor cur_opn(p_chr_id number) is
3673: SELECT a.subject_chr_id,
3674: a.process_flag -- bugfix 2952330, selecting Process_flag to check the value 'A'
3675: FROM okc_operation_lines a,okc_operation_instances b, okc_class_operations c
3676: where a.object_chr_id=p_chr_id and
3677: c.id=b.cop_id and
3678: c.opn_code in ('RENEWAL', 'REN_CON')
3679: and b.id=a.oie_id and