APPS.WIP_JOBCLOSE_PRIV dependencies on WIP_ENTITIES

Line 67: WIP_ENTITIES WE

63: x_group_id,
64: p_act_close_date
65: FROM ORG_ACCT_PERIODS AP,
66: WIP_DISCRETE_JOBS DJ,
67: WIP_ENTITIES WE
68: WHERE DJ.ORGANIZATION_ID = p_organization_id
69: AND WE.ORGANIZATION_ID = DJ.ORGANIZATION_ID
70: AND AP.ORGANIZATION_ID = DJ.ORGANIZATION_ID
71: AND AP.OPEN_FLAG = 'Y'

Line 624: wip_entities we

620: cursor c_jobs is
621: select wdct.wip_entity_id,
622: we.organization_id
623: from wip_dj_close_temp wdct,
624: wip_entities we
625: where we.wip_entity_id = wdct.wip_entity_id
626: and we.organization_id = wdct.organization_id
627: and wdct.group_id = p_group_id
628: and wdct.organization_id = p_organization_id;

Line 666: wip_entities we

662: cursor c_jobs is
663: select wdct.wip_entity_id,
664: we.wip_entity_name
665: from wip_dj_close_temp wdct,
666: wip_entities we
667: where we.wip_entity_id = wdct.wip_entity_id
668: and we.organization_id = wdct.organization_id
669: and wdct.group_id = p_group_id
670: and wdct.organization_id = p_organization_id;

Line 767: wip_entities we

763: select wdct.wip_entity_id,
764: we.entity_type,
765: we.wip_entity_name
766: from wip_dj_close_temp wdct,
767: wip_entities we
768: where we.wip_entity_id = wdct.wip_entity_id
769: and we.organization_id = wdct.organization_id
770: and wdct.group_id = p_group_id
771: and wdct.organization_id = p_organization_id;

Line 823: wip_entities we

819: cursor c_jobs is
820: select wdct.wip_entity_id,
821: we.entity_type
822: from wip_dj_close_temp wdct,
823: wip_entities we
824: where we.wip_entity_id = wdct.wip_entity_id
825: and we.organization_id = wdct.organization_id
826: and wdct.group_id = p_group_id
827: and wdct.organization_id = p_organization_id;

Line 2141: WIP_ENTITIES we

2137: we.ENTITY_TYPE,
2138: wdct.ACTUAL_CLOSE_DATE
2139: FROM WIP_DJ_CLOSE_TEMP wdct,
2140: ORG_ACCT_PERIODS oap,
2141: WIP_ENTITIES we
2142: WHERE wdct.GROUP_ID = l_group_id
2143: AND we.wip_entity_id = wdct.wip_entity_id
2144: AND we.organization_id = p_organization_id
2145: AND wdct.ORGANIZATION_ID = p_organization_id

Line 2237: UPDATE WIP_ENTITIES

2233: WHERE ORGANIZATION_ID = p_organization_id
2234: AND GROUP_ID = l_group_id);
2235:
2236:
2237: UPDATE WIP_ENTITIES
2238: SET ENTITY_TYPE = --DECODE(entity_type,6,7,5,8,3),
2239: DECODE(entity_type,
2240: WIP_CONSTANTS.EAM,
2241: WIP_CONSTANTS.CLOSED_EAM,