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 936: FROM pa_system_linkages st,

932: G_etype_link
933: , G_etype_labor_flag
934: , G_etec_start
935: , G_etec_end
936: FROM pa_system_linkages st,
937: pa_expend_typ_sys_links ets
938: WHERE st.function = ets.system_linkage_function
939: AND ets.system_linkage_function = X_system_linkage
940: AND ets.expenditure_type = X_etype ;