DBA Data[Home] [Help]

APPS.PA_TRX_IMPORT dependencies on PA_SYSTEM_LINKAGES

Line 196: as this is the size allowed in the base table pa_system_linkages.function,

192: G_NewTxnPrjId NUMBER;
193: --G_NewTxnsAllowed VARCHAR2(1);
194: G_EClassInfoEtype VARCHAR2(30);
195: /* bug #3134359 changed the size of G_EClassInfoSysLink to 30 from 3
196: as this is the size allowed in the base table pa_system_linkages.function,
197: size 30 is allowed in the front end also,ideally this should work with 3
198: if the values are from lookup */
199: --G_EClassInfoSysLink VARCHAR2(3);
200: G_EClassInfoSysLink VARCHAR2(30);

Line 866: FROM pa_system_linkages st,

862: G_etype_link
863: , G_etype_labor_flag
864: , G_etec_start
865: , G_etec_end
866: FROM pa_system_linkages st,
867: pa_expend_typ_sys_links ets
868: WHERE st.function = ets.system_linkage_function
869: AND ets.system_linkage_function = X_system_linkage
870: AND ets.expenditure_type = X_etype ;