DBA Data[Home] [Help]

APPS.JAI_PA_COSTING_PKG dependencies on PA_UTILS

Line 1921: Decode( nvl(VEND.employee_id, 0),0,NULL, PA_UTILS.GetEmpJobId(VEND.employee_id,po_DIST.Expenditure_Item_Date)) Job_id,

1917: po_dist.expenditure_type,
1918: po_dist.EXPENDITURE_ITEM_DATE,
1919: VEND.vendor_id vendor_id,
1920: po_dist.EXPENDITURE_ORGANIZATION_ID expenditure_organization_id,
1921: Decode( nvl(VEND.employee_id, 0),0,NULL, PA_UTILS.GetEmpJobId(VEND.employee_id,po_DIST.Expenditure_Item_Date)) Job_id,
1922: po_line.ITEM_DESCRIPTION description,
1923: po_dist.attribute_category,
1924: po_dist.attribute1,
1925: po_dist.attribute2,

Line 2072: SELECT pa_utils.getweekending(MAX(expenditure_item_date))

2068: FROM pa_implementations;
2069:
2070: /* Get the weekending date of the maximum expenditure item date of
2071: this PO distribution */
2072: SELECT pa_utils.getweekending(MAX(expenditure_item_date))
2073: INTO ld_expenditure_ending_date
2074: FROM po_distributions
2075: WHERE po_distribution_id = rec_rcv_receipts.po_distribution_id;
2076: