[Home] [Help]
APPS.PJM_TRANSFER_IPV_PKG dependencies on PJM_TASK_AUTO_ASSIGN
Line 75: SELECT PJM_TASK_AUTO_ASSIGN.Inv_Task_WNPS
71: , X_Project_Id IN NUMBER
72: ) RETURN VARCHAR2 IS
73:
74: CURSOR c_inv IS
75: SELECT PJM_TASK_AUTO_ASSIGN.Inv_Task_WNPS
76: ( POD.Destination_Organization_Id
77: , X_Project_Id
78: , POL.Item_Id
79: , POD.Po_Header_Id
Line 88: SELECT PJM_TASK_AUTO_ASSIGN.WIP_Task_WNPS
84: WHERE POD.PO_Distribution_Id = X_PO_Distribution_Id
85: AND POL.PO_Line_Id = POD.PO_Line_Id;
86:
87: CURSOR c_wip IS
88: SELECT PJM_TASK_AUTO_ASSIGN.WIP_Task_WNPS
89: ( wo.organization_id
90: , X_Project_Id
91: , wo.standard_operation_id
92: , wdj.wip_entity_id