APPS.CSTPPIPV dependencies on ORG_ACCT_PERIODS

Line 1370: org_acct_periods oap,

1366: p_adj_account
1367: FROM cst_ap_variance_headers cavh,
1368: po_distributions_all pda,
1369: wip_operation_resources wor,
1370: org_acct_periods oap,
1371: mtl_parameters mp,
1372: fnd_user fu
1373: WHERE cavh.batch_id = l_batch_id
1374: AND cavh.var_amount <> 0

Line 2292: FROM org_acct_periods oap

2288: SELECT MIN(oap.period_start_date) ,
2289: MAX(oap.schedule_close_date)+.99999
2290: INTO l_first_date ,
2291: l_last_date
2292: FROM org_acct_periods oap
2293: WHERE oap.organization_id = p_organization_id
2294: AND oap.open_flag = 'Y'
2295: AND oap.period_close_date is NULL;
2296:

Line 2381: FROM org_acct_periods oap

2377: MAX(oap.schedule_close_date)+(1-1/86400) -- +.99999 BUG#5709567-FPBIG#5109100
2378: --Bug #13075737, Release commented code and modify to +(1-1/86400)
2379: INTO l_first_date ,
2380: l_last_date
2381: FROM org_acct_periods oap
2382: WHERE oap.organization_id = p_organization_id
2383: AND oap.open_flag = 'Y'
2384: AND oap.period_close_date is NULL;
2385: