DBA Data[Home] [Help]

APPS.CST_ACCRUAL_REC_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 1338: from po_distributions_all pod,

1334: l_erv_id,
1335: l_wo_cc,
1336: l_wo_ct,
1337: l_wo_cd
1338: from po_distributions_all pod,
1339: po_line_locations_all poll,
1340: po_headers_all poh
1341: where pod.po_distribution_id = c_wo_rec.po_distribution_id
1342: and pod.org_id = p_ou_id

Line 1358: from po_distributions_all pod,

1354: gl_currency_api.get_rate(poh.currency_code, gsb.currency_code,
1355: trunc(p_wo_date),poh.rate_type)
1356: )
1357: into l_wo_cr
1358: from po_distributions_all pod,
1359: po_line_locations_all poll,
1360: po_headers_all poh,
1361: gl_sets_of_books gsb
1362: where pod.po_distribution_id = c_wo_rec.po_distribution_id

Line 1375: from po_distributions_all pod

1371: Select NVL(pod.rate,1),
1372: NVL(pod.rate_date,TRUNC(pod.creation_date))
1373: into l_wo_cr,
1374: l_wo_cd
1375: from po_distributions_all pod
1376: where pod.po_distribution_id = c_wo_rec.po_distribution_id
1377: and pod.org_id = p_ou_id ;
1378:
1379: END;