APPS.WSM_JOBCOSTING_GRP dependencies on ORG_ACCT_PERIODS

Line 52: FROM org_acct_periods

48: l_acct_period_id := -1;
49: BEGIN
50: SELECT acct_period_id
51: INTO l_acct_period_id
52: FROM org_acct_periods
53: WHERE organization_id = l_org_id
54: AND trunc(nvl(l_txn_date, sysdate))
55: between PERIOD_START_DATE and SCHEDULE_CLOSE_DATE
56: AND period_close_date is NULL

Line 126: org_acct_periods OAP,

122: FROM wsm_sm_starting_jobs WSSJ,
123: wsm_split_merge_transactions WSMT,
124: wsm_sm_resulting_jobs WSRJ,
125: mtl_system_items MSI,
126: org_acct_periods OAP,
127: mtl_transaction_types MTT
128: WHERE WSMT.transaction_id = p_txn_id
129: AND WSMT.transaction_id = decode(WSMT.transaction_type_id, WSMPCNST.BONUS, WSMT.transaction_id,
130: WSSJ.transaction_id)