DBA Data[Home] [Help]

APPS.INVPULI3 dependencies on PA_EGO_PHASES_V

Line 23: ,pa_ego_phases_v phase

19: IS
20: SELECT 'Y' FROM DUAL
21: WHERE EXISTS (SELECT NULL
22: FROM ego_lcphase_item_status status
23: ,pa_ego_phases_v phase
24: WHERE status.phase_code = phase.phase_code
25: AND proj_element_id = cp_phase_id
26: AND status.item_status_code = cp_status_code);
27: CURSOR c_default_status (Cp_phase_id NUMBER)

Line 31: ,pa_ego_phases_v phase

27: CURSOR c_default_status (Cp_phase_id NUMBER)
28: IS
29: SELECT status.item_status_code
30: FROM ego_lcphase_item_status status
31: ,pa_ego_phases_v phase
32: WHERE status.phase_code = phase.phase_code
33: AND proj_element_id = Cp_phase_id
34: AND status.default_flag = 'Y';
35: