APPS.JL_BR_SPED_PKG dependencies on AR_TRX_HEADER_GT

Line 1017: FROM AR_TRX_HEADER_GT GT

1013: GT.GLOBAL_ATTRIBUTE29,
1014: GT.GLOBAL_ATTRIBUTE30,
1015: GT.GLOBAL_ATTRIBUTE18,
1016: GT.GLOBAL_ATTRIBUTE28
1017: FROM AR_TRX_HEADER_GT GT
1018: WHERE GT.CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
1019:
1020: -- BUG 10184720
1021: -- Cursor Added for capturing additional Towing Attributes

Line 1033: FROM AR_TRX_HEADER_GT GT,

1029: T.TOWING_VEH_PLATE_STATE_CODE4,
1030: T.TOWING_VEH_PLATE_NUMBER5,
1031: T.TOWING_VEH_PLATE_STATE_CODE5,
1032: T.SRV_EXEC_DATE --BUG 11825724
1033: FROM AR_TRX_HEADER_GT GT,
1034: JL_BR_INV_API_TRX_LINES_T T
1035: WHERE GT.CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID
1036: AND GT.TRX_HEADER_ID = T.TRX_HEADER_ID
1037: AND T.TRX_LINE_ID IS NULL; --bug 10265440

Line 1335: WHERE TRX_HEADER_ID IN (SELECT TRX_HEADER_ID FROM AR_TRX_HEADER_GT

1331: END IF;
1332: -- Deleting Data from Temporary table once it has been copied to core JL table
1333: -- BUG 10184720
1334: DELETE FROM JL_BR_INV_API_TRX_LINES_T
1335: WHERE TRX_HEADER_ID IN (SELECT TRX_HEADER_ID FROM AR_TRX_HEADER_GT
1336: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID);
1337: END IF; -- main IF country code = 'BR'
1338:
1339: RETURN 1;