DBA Data[Home] [Help]

APPS.PA_TRX_IMPORT dependencies on PA_EXPEND_TYP_SYS_LINKS

Line 937: pa_expend_typ_sys_links ets

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

Line 1312: pa_expend_typ_sys_links sl

1308: nvl(sl.end_date_active, p_exp_item_date) sl_end_date
1309: from pa_projects_all p,
1310: pa_tasks t,
1311: pa_expenditure_types et,
1312: pa_expend_typ_sys_links sl
1313: where p.project_id = p_project_id
1314: and t.project_id = p_project_id
1315: and t.task_id = p_task_id
1316: and et.expenditure_type = p_exp_type

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

2642: -- * Expenditure type has same system linkage as transaction source
2643: -- 07/15/97- selva: This above condition is not valid after project Manuf. changes.
2644: -- * Expenditure type is active as of the transaction item date
2645: -- IF ( last_etype IS NULL OR x_etype <> last_etype ) THEN
2646: -- Check pa_expend_typ_sys_links table for for existence and activeness of
2647: -- the given exp_type/sys_link combination
2648:
2649: IF PG_DEBUG = 'Y' THEN
2650: pa_debug.G_err_stage := 'Calling GetEtypeEclassInfo';