DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_RECORDING_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 1202: FROM JAI_CMN_INVENTORY_ORGS a

1198: jai_constants.register_type_a, modvat_rm_account_id,
1199: jai_constants.register_type_c, modvat_cg_account_id,
1200: jai_constants.register_type_pla, modvat_pla_account_id
1201: )
1202: FROM JAI_CMN_INVENTORY_ORGS a
1203: WHERE organization_id = cp_organization_id
1204: AND ( (cp_location_id IS NOT NULL AND a.location_id = cp_location_id)
1205: OR (cp_location_id IS NULL AND (a.location_id IS NULL OR a.location_id = 0))
1206: );

Line 1218: FROM JAI_CMN_INVENTORY_ORGS a

1214: jai_constants.register_type_a, excise_edu_cess_rm_account ,
1215: jai_constants.register_type_c, excise_edu_cess_cg_account ,
1216: jai_constants.register_type_pla, modvat_pla_account_id
1217: )
1218: FROM JAI_CMN_INVENTORY_ORGS a
1219: WHERE organization_id = cp_organization_id
1220: AND ( (cp_location_id IS NOT NULL AND a.location_id = cp_location_id)
1221: OR (cp_location_id IS NULL AND (a.location_id IS NULL OR a.location_id = 0))
1222: );

Line 1238: FROM JAI_CMN_INVENTORY_ORGS a

1234: jai_constants.register_type_a, SH_CESS_RM_ACCOUNT ,
1235: jai_constants.register_type_c, SH_CESS_CG_ACCOUNT_ID ,
1236: jai_constants.register_type_pla, modvat_pla_account_id
1237: )
1238: FROM JAI_CMN_INVENTORY_ORGS a
1239: WHERE organization_id = cp_organization_id
1240: AND ( (cp_location_id IS NOT NULL AND a.location_id = cp_location_id)
1241: OR (cp_location_id IS NULL AND (a.location_id IS NULL OR a.location_id = 0))
1242: );