DBA Data[Home] [Help]

APPS.JAI_AR_EER1_PKG dependencies on JAI_CMN_RG_PLA_HDRS

Line 3878: from JAI_CMN_RG_PLA_HDRS a

3874:
3875: Cursor c_tr6_challan_amt
3876: is
3877: select NVL(SUM(pla_amount),0)
3878: from JAI_CMN_RG_PLA_HDRS a
3879: where a.organization_id = p_organization_id
3880: and a.location_id = p_location_id
3881: and trunc(a.creation_date) >= p_start_date
3882: and trunc(a.creation_date) <= p_end_date