APPS.JA_CN_COA_EXPORT_PKG dependencies on FND_LOOKUP_VALUES

Line 217: l_na_req_phase fnd_lookup_values.meaning%TYPE;

213: l_template_language VARCHAR2(10) := pv_xml_template_language;
214: l_template_territory VARCHAR2(10) := pv_xml_template_territory;
215: l_output_format VARCHAR2(10) := pv_xml_output_format;
216: l_na_req_id NUMBER; --Request id for concurrent program 'Generating Natural Account Export Exception Report'
217: l_na_req_phase fnd_lookup_values.meaning%TYPE;
218: l_na_req_status fnd_lookup_values.meaning%TYPE;
219: l_na_req_dev_phase VARCHAR2(30);
220: l_na_req_dev_status VARCHAR2(30);
221: l_na_req_message VARCHAR2(100);

Line 218: l_na_req_status fnd_lookup_values.meaning%TYPE;

214: l_template_territory VARCHAR2(10) := pv_xml_template_territory;
215: l_output_format VARCHAR2(10) := pv_xml_output_format;
216: l_na_req_id NUMBER; --Request id for concurrent program 'Generating Natural Account Export Exception Report'
217: l_na_req_phase fnd_lookup_values.meaning%TYPE;
218: l_na_req_status fnd_lookup_values.meaning%TYPE;
219: l_na_req_dev_phase VARCHAR2(30);
220: l_na_req_dev_status VARCHAR2(30);
221: l_na_req_message VARCHAR2(100);
222:

Line 605: FROM FND_LOOKUP_VALUES FLV

601: SELECT nvl(FLV.meaning,'') acc_type
602: ,FLV1.meaning acc_bal_side
603: INTO l_na_type
604: ,l_na_bal
605: FROM FND_LOOKUP_VALUES FLV
606: ,FND_LOOKUP_VALUES FLV1
607: WHERE --Get meaning of account type
608: FLV.lookup_code = l_acc_type_code --using variable l_acc_type_code
609: AND FLV.lookup_type = l_ent_acc_type --'ACCOUNT_TYPE'

Line 606: ,FND_LOOKUP_VALUES FLV1

602: ,FLV1.meaning acc_bal_side
603: INTO l_na_type
604: ,l_na_bal
605: FROM FND_LOOKUP_VALUES FLV
606: ,FND_LOOKUP_VALUES FLV1
607: WHERE --Get meaning of account type
608: FLV.lookup_code = l_acc_type_code --using variable l_acc_type_code
609: AND FLV.lookup_type = l_ent_acc_type --'ACCOUNT_TYPE'
610: and FLV.LANGUAGE = userenv('LANG')