DBA Data[Home] [Help]

APPS.ZX_FC_MIGRATE_PKG dependencies on JL_BR_AP_OPERATIONS

Line 1147: FROM JL_BR_AP_OPERATIONS JLBR

1143: fnd_global.user_id,
1144: SYSDATE,
1145: FND_GLOBAL.CONC_LOGIN_ID,
1146: 1
1147: FROM JL_BR_AP_OPERATIONS JLBR
1148: WHERE NOT EXISTS
1149: -- this condition makes sure we dont duplicate data
1150: (select NULL from ZX_FC_CODES_B Codes where
1151: codes.classification_type_code = 'USER_DEFINED'

Line 1284: JL_BR_AP_OPERATIONS JLBR,

1280: JLBR.creation_date ,
1281: l.language_code lang_code,
1282: codes.classification_id
1283: FROM ZX_FC_CODES_B Codes,
1284: JL_BR_AP_OPERATIONS JLBR,
1285: FND_LANGUAGES L
1286: WHERE Codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
1287: and Codes.parent_classification_id is null
1288: AND Codes.classification_code=JLBR.cfo_code

Line 1354: JL_BR_AP_OPERATIONS ap_op,

1350: SYSDATE,
1351: FND_GLOBAL.CONC_LOGIN_ID,
1352: 1
1353: FROM
1354: JL_BR_AP_OPERATIONS ap_op,
1355: ZX_FC_CODES_DENORM_B fc,
1356: ZX_EVENT_CLASSES_VL event
1357: WHERE
1358: fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'

Line 1507: JL_BR_AP_OPERATIONS ap_op,

1503: l.language_code lang_code
1504: FROM
1505: ZX_FC_CODES_DENORM_B fc,
1506: ZX_FC_CODES_B Codes,
1507: JL_BR_AP_OPERATIONS ap_op,
1508: FND_LANGUAGES L,
1509: ZX_EVENT_CLASSES_VL event
1510: WHERE
1511: fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'