APPS.CSTPPIPV dependencies on ORG_ACCT_PERIODS

Line 1324: org_acct_periods oap,

1320: p_adj_account
1321: FROM cst_ap_variance_headers cavh,
1322: po_distributions_all pda,
1323: wip_operation_resources wor,
1324: org_acct_periods oap,
1325: mtl_parameters mp,
1326: fnd_user fu
1327: WHERE cavh.batch_id = l_batch_id
1328: AND cavh.var_amount <> 0

Line 2206: -- FROM org_acct_periods oap

2202: -- SELECT MIN(oap.period_start_date) ,
2203: -- MAX(oap.schedule_close_date)+.99999
2204: -- INTO l_first_date ,
2205: -- l_last_date
2206: -- FROM org_acct_periods oap
2207: -- WHERE oap.organization_id = p_organization_id
2208: -- AND oap.open_flag = 'Y'
2209: -- AND oap.period_close_date is NULL;
2210: --

Line 2294: FROM org_acct_periods oap

2290: SELECT MIN(oap.period_start_date) ,
2291: MAX(oap.schedule_close_date) -- +.99999 BUG#5709567-FPBIG#5109100
2292: INTO l_first_date ,
2293: l_last_date
2294: FROM org_acct_periods oap
2295: WHERE oap.organization_id = p_organization_id
2296: AND oap.open_flag = 'Y'
2297: AND oap.period_close_date is NULL;
2298: