APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PO_DISTRIBUTIONS_ALL

Line 1455: FROM po_distributions_all pod

1451: CURSOR get_podetails Is
1452: SELECT 'PO'
1453: ,po_header_id
1454: ,po_distribution_id
1455: FROM po_distributions_all pod
1456: WHERE pod.req_distribution_id = p_req_distribution_id ;
1457:
1458: CURSOR c_req_raw_burden IS
1459: SELECT parent_bc_packet_id

Line 1577: L_CC_HEADER_ID varchar2(30); --Bug 6393954 changed from PO_DISTRIBUTIONS_ALL.PO_HEADER_ID%TYPE to varchar2

1573: l_cc_found_flag VARCHAR2(1) := 'N';
1574: l_return_flag VARCHAR2(1) := 'N';
1575: l_cc_det_pf_line_id varchar2(30); --Bug 6393954 changed from number to varchar2
1576: L_PARENT_BC_PACKET_ID PA_BC_PACKETS.PARENT_BC_PACKET_ID%TYPE;
1577: L_CC_HEADER_ID varchar2(30); --Bug 6393954 changed from PO_DISTRIBUTIONS_ALL.PO_HEADER_ID%TYPE to varchar2
1578: L_PO_DESTINATION_TYPE PO_DISTRIBUTIONS_ALL.DESTINATION_TYPE_CODE%TYPE;
1579:
1580: -- this cursor checks whehter the AP is based on Purchase Order if so then
1581: -- take the calculated burden amount from pa_bc_commitments table

Line 1578: L_PO_DESTINATION_TYPE PO_DISTRIBUTIONS_ALL.DESTINATION_TYPE_CODE%TYPE;

1574: l_return_flag VARCHAR2(1) := 'N';
1575: l_cc_det_pf_line_id varchar2(30); --Bug 6393954 changed from number to varchar2
1576: L_PARENT_BC_PACKET_ID PA_BC_PACKETS.PARENT_BC_PACKET_ID%TYPE;
1577: L_CC_HEADER_ID varchar2(30); --Bug 6393954 changed from PO_DISTRIBUTIONS_ALL.PO_HEADER_ID%TYPE to varchar2
1578: L_PO_DESTINATION_TYPE PO_DISTRIBUTIONS_ALL.DESTINATION_TYPE_CODE%TYPE;
1579:
1580: -- this cursor checks whehter the AP is based on Purchase Order if so then
1581: -- take the calculated burden amount from pa_bc_commitments table
1582: CURSOR po_cur is

Line 1586: FROM po_distributions_all po

1582: CURSOR po_cur is
1583: SELECT po.req_header_reference_num
1584: ,po.req_line_reference_num
1585: ,po.destination_type_code
1586: FROM po_distributions_all po
1587: WHERE po.po_distribution_id = p_po_distribution_id;
1588:
1589: CURSOR c_po_raw_burden(p_distribution_id NUMBER,
1590: p_header_id NUMBER,

Line 1814: FROM po_distributions_all po

1810: (SELECT encumbrance_type_id
1811: FROM gl_encumbrance_types
1812: WHERE encumbrance_type_KEY = 'Obligation') po_encumbrance_type_id ,
1813: po.rate -- Bug 5665232
1814: FROM po_distributions_all po
1815: WHERE po.po_distribution_id = p_po_distribution_id;
1816:
1817:
1818: CURSOR c_po_dist_type (p_po_header_id NUMBER,

Line 2041: FROM po_distributions_all po

2037: po.po_line_id,
2038: po.po_distribution_id,
2039: po.org_id) cwk_po_flag,
2040: NVL(po.accrue_on_receipt_flag,'N') accrue_on_receipt_flag
2041: FROM po_distributions_all po
2042: WHERE po.po_distribution_id = p_po_distribution_id;
2043:
2044: BEGIN
2045:

Line 2650: FROM po_distributions_all pord

2646: AND porl.requisition_line_id = pobc.line_id
2647: AND pobc.distribution_type = 'REQUISITION'
2648: UNION ALL
2649: SELECT 1
2650: FROM po_distributions_all pord
2651: WHERE nvl(pord.DESTINATION_TYPE_CODE,'EXPENSE') = 'EXPENSE'
2652: AND pord.po_distribution_id = pobc.distribution_id
2653: AND pobc.distribution_type <> 'REQUISITION' )
2654: /** Bug fix : 2347699 added this check to make sure that project is not cross charged **/

Line 2716: FROM po_distributions_all pod

2712: -- Bug 5533290 : AP TAX Distribution matched to CWK PO will be fundschecked only for the
2713: -- the variance amount.Even tough AP TAX is eligible for interface to projects,the commitment amount
2714: -- will remain with PO and during interface will be relieved from PO bucket
2715: AND NOT EXISTS ( SELECT 1
2716: FROM po_distributions_all pod
2717: WHERE pod.po_distribution_id = apd.po_distribution_id
2718: AND apd.po_distribution_id IS NOT NULL
2719: AND ((NVL(pod.accrue_on_receipt_flag,'N') = 'Y' -- Bug 5348212
2720: AND apd.line_type_lookup_code IN ('ITEM','ACCRUAL','NONREC_TAX'))