DBA Data[Home] [Help]

APPS.OKE_ALLOCATION_PVT dependencies on OKE_K_LINES

Line 621: from oke_k_lines

617: p_return_status OUT NOCOPY VARCHAR2
618: ) is
619: cursor c_line_id is
620: select 'x'
621: from oke_k_lines
622: where k_line_id = p_k_line_id;
623:
624: cursor c_header is
625: select pa_flag

Line 631: from oke_k_lines

627: where fund_allocation_id = p_fund_allocation_id;
628:
629: cursor c_line_project is
630: select project_id, task_id
631: from oke_k_lines
632: where k_line_id = p_k_line_id;
633:
634: cursor c_valid_line (x_project_id number) is
635: select 'x'

Line 660: from oke_k_lines

656: cursor c_line (x_line_id number) is
657: select project_id,
658: parent_line_id,
659: task_id
660: from oke_k_lines
661: where k_line_id = x_line_id;
662:
663: l_dummy_value VARCHAR2(1) := '?';
664: l_flag VARCHAR2(1);

Line 806: from oke_k_lines_v

802:
803: cursor c_line_project is
804: select project_id,
805: task_id
806: from oke_k_lines_v
807: where header_id = p_object_id
808: and k_line_id = p_k_line_id;
809:
810: cursor c_master_project is

Line 886: from oke_k_lines

882: cursor c_project_2 (x_line_id number) is
883: select project_id,
884: parent_line_id,
885: task_id
886: from oke_k_lines
887: where k_line_id = x_line_id;
888:
889: l_dummy_value VARCHAR2(1) := '?';
890: l_project_id NUMBER;