APPS.FV_SLA_PROCESSING_PKG dependencies on PO_BC_DISTRIBUTIONS

Line 1017: SELECT accounted_amt, event_type_code,code_combination_id FROM PO_BC_DISTRIBUTIONS

1013: l_debug_info VARCHAR2(240);
1014: l_procedure_name VARCHAR2(100) :='.PYA_ADJ_AMT_BY_FUND';
1015:
1016: CURSOR c_net_adj_amt (p_dist_id NUMBER) IS
1017: SELECT accounted_amt, event_type_code,code_combination_id FROM PO_BC_DISTRIBUTIONS
1018: WHERE distribution_id = p_dist_id AND ae_event_id =
1019: (SELECT max(ae_event_id) FROM PO_BC_DISTRIBUTIONS pbd
1020: WHERE distribution_id = p_dist_id
1021: AND main_or_backing_code = 'M'

Line 1019: (SELECT max(ae_event_id) FROM PO_BC_DISTRIBUTIONS pbd

1015:
1016: CURSOR c_net_adj_amt (p_dist_id NUMBER) IS
1017: SELECT accounted_amt, event_type_code,code_combination_id FROM PO_BC_DISTRIBUTIONS
1018: WHERE distribution_id = p_dist_id AND ae_event_id =
1019: (SELECT max(ae_event_id) FROM PO_BC_DISTRIBUTIONS pbd
1020: WHERE distribution_id = p_dist_id
1021: AND main_or_backing_code = 'M'
1022: AND ae_event_id <> p_event_id
1023: AND distribution_type <> 'REQUISITION'

Line 1030: --currently we are using only po_bc_distributions only, but infuture we may

1026: where application_id = 201
1027: and xah.event_id = pbd.ae_event_id
1028: and xah.accounting_entry_status_code = 'F'));
1029:
1030: --currently we are using only po_bc_distributions only, but infuture we may
1031: --have to use gl_bc_packets or xla_events
1032:
1033: /*Get all the distribution ids in p_event_id event which belong to the same document*/
1034: CURSOR c_get_dist_ids IS

Line 1036: FROM PO_EXTRACT_DETAIL_V ped, PO_BC_DISTRIBUTIONS pbd

1032:
1033: /*Get all the distribution ids in p_event_id event which belong to the same document*/
1034: CURSOR c_get_dist_ids IS
1035: SELECT pbd.distribution_id,pbd.code_combination_id,pbd.accounted_amt
1036: FROM PO_EXTRACT_DETAIL_V ped, PO_BC_DISTRIBUTIONS pbd
1037: WHERE ped.event_id = pbd.ae_event_id --p_event_id AND
1038: AND ped.po_distribution_id = pbd.distribution_id
1039: AND pbd.header_id = p_header_id
1040: AND pbd.main_or_backing_code = 'M';

Line 1637: SELECT accounted_amt,event_type_code,code_combination_id FROM PO_BC_DISTRIBUTIONS

1633:
1634:
1635:
1636: CURSOR c_old_amt (p_dist_id NUMBER, p_event_id NUMBER) IS
1637: SELECT accounted_amt,event_type_code,code_combination_id FROM PO_BC_DISTRIBUTIONS
1638: WHERE distribution_id = p_dist_id AND ae_event_id =
1639: (SELECT max(ae_event_id) FROM PO_BC_DISTRIBUTIONS pbd
1640: WHERE pbd.distribution_id = p_dist_id
1641: AND pbd.ae_event_id <> p_event_id

Line 1639: (SELECT max(ae_event_id) FROM PO_BC_DISTRIBUTIONS pbd

1635:
1636: CURSOR c_old_amt (p_dist_id NUMBER, p_event_id NUMBER) IS
1637: SELECT accounted_amt,event_type_code,code_combination_id FROM PO_BC_DISTRIBUTIONS
1638: WHERE distribution_id = p_dist_id AND ae_event_id =
1639: (SELECT max(ae_event_id) FROM PO_BC_DISTRIBUTIONS pbd
1640: WHERE pbd.distribution_id = p_dist_id
1641: AND pbd.ae_event_id <> p_event_id
1642: AND pbd.distribution_type <> 'REQUISITION'
1643: AND pbd.main_or_backing_code = 'M'

Line 1652: FROM po_bc_distributions

1648: and xah.accounting_entry_status_code = 'F') );
1649:
1650: cursor c_event_type_code (p_event_id number) IS
1651: SELECT event_type_code
1652: FROM po_bc_distributions
1653: WHERE ae_event_id = p_event_id;
1654:
1655:
1656: