DBA Data[Home] [Help]

APPS.JA_JAINER1_XMLP_PKG dependencies on JAI_CMN_RG_PLA_HDRS

Line 1399: JAI_CMN_RG_PLA_HDRS A

1395: NVL(SUM(PLA_AMOUNT)
1396: ,0)
1397: INTO LN_PLA_AMOUNT
1398: FROM
1399: JAI_CMN_RG_PLA_HDRS A
1400: WHERE A.ORGANIZATION_ID = P_ORGANIZATION_ID
1401: AND A.LOCATION_ID = P_LOCATION_ID
1402: AND TRUNC(A.TR6_DATE) >= P_START_DATE
1403: AND TRUNC(A.TR6_DATE) <= P_END_DATE

Line 2511: JAI_CMN_RG_PLA_HDRS A

2507: NVL(SUM(PLA_AMOUNT)
2508: ,0)
2509: INTO LN_PLA_AMOUNT
2510: FROM
2511: JAI_CMN_RG_PLA_HDRS A
2512: WHERE A.ORGANIZATION_ID = P_ORGANIZATION_ID
2513: AND A.LOCATION_ID = P_LOCATION_ID
2514: AND TRUNC(A.TR6_DATE) >= P_START_DATE
2515: AND TRUNC(A.TR6_DATE) <= P_END_DATE