DBA Data[Home] [Help]

APPS.JAI_RCV_RT_TRIGGER_PKG dependencies on HR_LOCATIONS_ALL

Line 70: hr_locations_all hla

66: /*Added cursor get_rma_loc for Bug 15936238 by mmurtuza*/
67: cursor get_rma_loc(p_organization_id number) is
68: SELECT haou.location_id
69: FROM hr_all_organization_units haou,
70: hr_locations_all hla
71: WHERE haou.organization_id = p_organization_id
72: AND haou.location_id = hla.location_id;
73:
74: /*Start Additions for Bug 14176672 by mmurtuza*/

Line 143: Fix: Added cursor get_rma_loc to location_id from hr_locations_all if location_id is null in rcv_transactions

139: Fix: Fetched Excise Invoice Number and Date from ASN and populated the same to Localized Receipt Tables
140:
141: 12. 13-Dec-2012 mmurtuza for bug 15936238
142: Description: INDIA LOC - RECEIVING RMA RECEIPT FAILS
143: Fix: Added cursor get_rma_loc to location_id from hr_locations_all if location_id is null in rcv_transactions
144: and passed the same to cursor chk_org_setup_is_present when checking localization setup.
145:
146: 13. 21-Dec-2012 vkavulur for bug #14852106
147: Description - In case correction is done for a receipt without claiming the cenvat, an error has to be shown