APPS.WIP_JOBCLOSE_PRIV dependencies on ORG_ACCT_PERIODS

Line 65: FROM ORG_ACCT_PERIODS AP,

61: DJ.PRIMARY_ITEM_ID,
62: DJ.STATUS_TYPE,
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

Line 1417: FROM ORG_ACCT_PERIODS

1413: to_char(SCHEDULE_CLOSE_DATE,'YYYY/MM/DD')
1414: INTO l_acct_period_id ,
1415: l_per_str_date,
1416: l_per_cls_date
1417: FROM ORG_ACCT_PERIODS
1418: WHERE INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (SYSDATE, p_organization_id) >= TRUNC(PERIOD_START_DATE)
1419: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (SYSDATE, p_organization_id) <= TRUNC(SCHEDULE_CLOSE_DATE)
1420: AND ORGANIZATION_ID = p_organization_id;
1421:

Line 1734: FROM ORG_ACCT_PERIODS

1730: BEGIN
1731:
1732: SELECT ACCT_PERIOD_ID
1733: INTO l_acct_period_id
1734: FROM ORG_ACCT_PERIODS
1735: WHERE ORGANIZATION_ID = p_organization_id
1736: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (l_act_close_date,p_organization_id)
1737: BETWEEN PERIOD_START_DATE AND SCHEDULE_CLOSE_DATE
1738: AND PERIOD_CLOSE_DATE IS NULL;

Line 2065: FROM ORG_ACCT_PERIODS

2061:
2062:
2063: SELECT ACCT_PERIOD_ID
2064: INTO l_acct_period_id
2065: FROM ORG_ACCT_PERIODS
2066: WHERE TRUNC(SYSDATE) >= TRUNC(PERIOD_START_DATE)
2067: AND TRUNC(SYSDATE) <= TRUNC(SCHEDULE_CLOSE_DATE)
2068: AND ORGANIZATION_ID = p_organization_id;
2069:

Line 2140: ORG_ACCT_PERIODS oap,

2136: wdct.WIP_ENTITY_NAME,
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