DBA Data[Home] [Help]

APPS.JA_CN_FSG_XML_SUBMIT_PROG dependencies on JA_CN_SYSTEM_PARAMETERS_ALL

Line 136: FROM JA_CN_SYSTEM_PARAMETERS_ALL

132: L_LEGAL_ENTITY:=Fnd_Profile.VALUE(NAME => 'JA_CN_LEGAL_ENTITY');
133: --get company name
134: SELECT COMPANY_NAME
135: INTO L_COMPANY_NAME
136: FROM JA_CN_SYSTEM_PARAMETERS_ALL
137: WHERE LEGAL_ENTITY_ID=L_LEGAL_ENTITY;
138:
139: SELECT row_set_id,
140: column_set_id,

Line 780: FROM JA_CN_SYSTEM_PARAMETERS_ALL

776: CURSOR C_COMPANY_NAME
777: IS
778: SELECT COMPANY_NAME
779: INTO Lv_company_name
780: FROM JA_CN_SYSTEM_PARAMETERS_ALL
781: WHERE LEGAL_ENTITY_ID= pn_legal_entity_id;
782:
783: BEGIN
784: --log for debug

Line 1778: FROM JA_CN_SYSTEM_PARAMETERS_ALL

1774: CURSOR C_COMPANY_NAME
1775: IS
1776: SELECT COMPANY_NAME
1777: INTO Lv_company_name
1778: FROM JA_CN_SYSTEM_PARAMETERS_ALL
1779: WHERE LEGAL_ENTITY_ID= pn_legal_entity_id;
1780:
1781: BEGIN
1782: --log for debug