APPS.JA_CN_CFS_DATA_CLT_PKG dependencies on FND_APPLICATION

Line 669: l_source_name fnd_application.application_short_name%TYPE;

665: l_le_id NUMBER :=P_LE_ID;
666: l_ledger_id NUMBER :=P_LEDGER_ID;
667: l_coa_id NUMBER :=P_COA_ID;
668: l_source_application_id NUMBER :=P_SOURCE_APP_ID;
669: l_source_name fnd_application.application_short_name%TYPE;
670: -- PERIODS e current item
671: l_period_name gl_periods.period_name%TYPE; --period name of th
672: l_period_year gl_periods.period_year%TYPE;
673: l_period_num gl_periods.period_num%TYPE;

Line 814: FROM FND_APPLICATION FAPP, JA_CN_CFS_ITEM_MAPPING_HDRS JCCIMH

810: -- should exclude AGIS, AP, AR in GL data collection.
811: AND jeh.je_source NOT IN ('Intercompany')--, 'Payables', 'Receivables'
812: -- exclude the source defined in in cash flow item mapping form (ja_cn_cfs_item_mapping_hdrs)
813: AND jeh.je_source NOT IN ( SELECT FAPP.APPLICATION_SHORT_NAME
814: FROM FND_APPLICATION FAPP, JA_CN_CFS_ITEM_MAPPING_HDRS JCCIMH
815: WHERE FAPP.APPLICATION_ID=JCCIMH.APPLICATION_ID
816: )
817: ;
818:

Line 990: --GET SOURCR SHORT NAME FROM FND_APPLICATION

986: IF ja_cn_utility.populate_ledger_le_bsv_gt( P_LEDGER_ID,P_LE_ID) <> 'S' THEN
987: RETURN;
988: END IF;
989:
990: --GET SOURCR SHORT NAME FROM FND_APPLICATION
991: SELECT appl.application_short_name
992: INTO l_source_name
993: FROM fnd_application appl
994: WHERE appl.application_id= l_source_application_id;

Line 993: FROM fnd_application appl

989:
990: --GET SOURCR SHORT NAME FROM FND_APPLICATION
991: SELECT appl.application_short_name
992: INTO l_source_name
993: FROM fnd_application appl
994: WHERE appl.application_id= l_source_application_id;
995:
996: --Collect Data from GL/GIS
997:

Line 1480: FROM fnd_application

1476: ELSE
1477: BEGIN
1478: SELECT application_id
1479: INTO l_source_id
1480: FROM fnd_application
1481: WHERE application_short_name = TO_CHAR(l_source);
1482: EXCEPTION
1483: WHEN no_data_found THEN
1484: l_source_id := NULL;