APPS.JA_CN_CFS_DATA_CLT_PKG dependencies on FND_APPLICATION

Line 651: l_source_name fnd_application.application_short_name%TYPE;

647: l_le_id NUMBER :=P_LE_ID;
648: l_ledger_id NUMBER :=P_LEDGER_ID;
649: l_coa_id NUMBER :=P_COA_ID;
650: l_source_application_id NUMBER :=P_SOURCE_APP_ID;
651: l_source_name fnd_application.application_short_name%TYPE;
652: -- PERIODS e current item
653: l_period_name gl_periods.period_name%TYPE; --period name of th
654: l_period_year gl_periods.period_year%TYPE;
655: l_period_num gl_periods.period_num%TYPE;

Line 796: FROM FND_APPLICATION FAPP, JA_CN_CFS_ITEM_MAPPING_HDRS JCCIMH

792: -- should exclude AGIS, AP, AR in GL data collection.
793: AND jeh.je_source NOT IN ('Intercompany')--, 'Payables', 'Receivables'
794: -- exclude the source defined in in cash flow item mapping form (ja_cn_cfs_item_mapping_hdrs)
795: AND jeh.je_source NOT IN ( SELECT FAPP.APPLICATION_SHORT_NAME
796: FROM FND_APPLICATION FAPP, JA_CN_CFS_ITEM_MAPPING_HDRS JCCIMH
797: WHERE FAPP.APPLICATION_ID=JCCIMH.APPLICATION_ID
798: )
799: ;
800:

Line 967: --GET SOURCR SHORT NAME FROM FND_APPLICATION

963: IF ja_cn_utility.populate_ledger_le_bsv_gt( P_LEDGER_ID,P_LE_ID) <> 'S' THEN
964: RETURN;
965: END IF;
966:
967: --GET SOURCR SHORT NAME FROM FND_APPLICATION
968: SELECT appl.application_short_name
969: INTO l_source_name
970: FROM fnd_application appl
971: WHERE appl.application_id= l_source_application_id;

Line 970: FROM fnd_application appl

966:
967: --GET SOURCR SHORT NAME FROM FND_APPLICATION
968: SELECT appl.application_short_name
969: INTO l_source_name
970: FROM fnd_application appl
971: WHERE appl.application_id= l_source_application_id;
972:
973: --Collect Data from GL/GIS
974:

Line 1429: FROM fnd_application

1425: ELSE
1426: BEGIN
1427: SELECT application_id
1428: INTO l_source_id
1429: FROM fnd_application
1430: WHERE application_short_name = TO_CHAR(l_source);
1431: EXCEPTION
1432: WHEN no_data_found THEN
1433: l_source_id := NULL;