DBA Data[Home] [Help]

APPS.PA_PROJ_ELEMENTS_UTILS dependencies on PA_ORG_LABOR_SCH_RULE

Line 5761: FROM pa_org_labor_sch_rule pol, table(cast(l_task_tbl as sub_task)) st

5757: FROM pa_comp_rule_ot_defaults_all pcr, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5758: where pcr.project_id = p_project_id
5759: AND pcr.TASK_ID = st.task_id)
5760: or exists (SELECT NULL
5761: FROM pa_org_labor_sch_rule pol, table(cast(l_task_tbl as sub_task)) st
5762: where overtime_project_id = p_project_id
5763: AND pol.overtime_TASK_ID = st.task_id);
5764:
5765: IF l_dummy = 1 THEN