DBA Data[Home] [Help]

APPS.PA_TRX_IMPORT dependencies on PA_EXPEND_TYP_SYS_LINKS

Line 867: pa_expend_typ_sys_links ets

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 ;
871:

Line 1221: pa_expend_typ_sys_links sl

1217: nvl(sl.end_date_active, p_exp_item_date) sl_end_date
1218: from pa_projects_all p,
1219: pa_tasks t,
1220: pa_expenditure_types et,
1221: pa_expend_typ_sys_links sl
1222: where p.project_id = p_project_id
1223: and t.project_id = p_project_id
1224: and t.task_id = p_task_id
1225: and et.expenditure_type = p_exp_type

Line 2383: -- Check pa_expend_typ_sys_links table for for existence and activeness of

2379: -- * Expenditure type has same system linkage as transaction source
2380: -- 07/15/97- selva: This above condition is not valid after project Manuf. changes.
2381: -- * Expenditure type is active as of the transaction item date
2382: -- IF ( last_etype IS NULL OR x_etype <> last_etype ) THEN
2383: -- Check pa_expend_typ_sys_links table for for existence and activeness of
2384: -- the given exp_type/sys_link combination
2385:
2386: IF PG_DEBUG = 'Y' THEN
2387: pa_debug.G_err_stage := 'Calling GetEtypeEclassInfo';