APPS.JL_ZZ_RECEIV_INTERFACE dependencies on JL_ZZ_AR_TX_FSC_CLS_ALL

Line 1044: FROM JL_ZZ_AR_TX_FSC_CLS_ALL

1040: -- AND fc.structure_name = 'Fiscal Classification' -- Commented for Bug#7125709
1041: AND fc.structure_code = 'FISCAL_CLASSIFICATION' -- Added as a fix for Bug#7125709
1042: AND EXISTS
1043: (SELECT 1
1044: FROM JL_ZZ_AR_TX_FSC_CLS_ALL
1045: WHERE fiscal_classification_code = fc.classification_code
1046: AND org_id = l_org_id
1047: AND enabled_flag = 'Y')
1048: AND ROWNUM =1;

Line 1079: FROM JL_ZZ_AR_TX_FSC_CLS_ALL

1075: -- AND fc.structure_name = 'Fiscal Classification' -- Commented for Bug#7125709
1076: AND fc.structure_code = 'FISCAL_CLASSIFICATION' -- Added as a fix for Bug#7125709
1077: AND EXISTS
1078: (SELECT 1
1079: FROM JL_ZZ_AR_TX_FSC_CLS_ALL
1080: WHERE fiscal_classification_code = fc.classification_code
1081: AND org_id = l_org_id
1082: AND enabled_flag = 'Y')
1083: AND ROWNUM =1;

Line 1286: FROM JL_ZZ_AR_TX_FSC_CLS_ALL

1282: AND fc.structure_code = 'FISCAL_CLASSIFICATION' -- Added as a fix for Bug#7125709
1283: AND rownum = 1
1284: AND EXISTS
1285: (SELECT 1
1286: FROM JL_ZZ_AR_TX_FSC_CLS_ALL
1287: WHERE fiscal_classification_code = fc.classification_code
1288: AND org_id = l_org_id
1289: AND enabled_flag = 'Y');
1290: EXCEPTION

Line 1320: FROM JL_ZZ_AR_TX_FSC_CLS_ALL

1316: -- AND fc.structure_name = 'Fiscal Classification' -- Commented for Bug#7125709
1317: AND fc.structure_code = 'FISCAL_CLASSIFICATION' -- Added as a fix for Bug#7125709
1318: AND EXISTS
1319: (SELECT 1
1320: FROM JL_ZZ_AR_TX_FSC_CLS_ALL
1321: WHERE fiscal_classification_code = fc.classification_code
1322: AND org_id = l_org_id
1323: AND enabled_flag = 'Y')
1324: AND ROWNUM =1;