DBA Data[Home] [Help]

APPS.PA_PROJ_TSK_UTILS dependencies on PA_ORG_LABOR_SCH_RULE

Line 1664: FROM pa_org_labor_sch_rule

1660: UNION
1661: SELECT 1
1662: FROM sys.dual
1663: WHERE EXISTS (SELECT NULL
1664: FROM pa_org_labor_sch_rule
1665: WHERE overtime_project_id = x_project_id);
1666:
1667: cursor c2 is
1668: SELECT 1

Line 1682: FROM pa_org_labor_sch_rule

1678: UNION
1679: SELECT 1
1680: FROM sys.dual
1681: where exists (SELECT NULL
1682: FROM pa_org_labor_sch_rule
1683: where overtime_project_id = x_proj_id
1684: AND overtime_TASK_ID IN
1685: (SELECT TASK_ID
1686: FROM PA_TASKS

Line 1714: FROM pa_org_labor_sch_rule

1710: FROM pa_comp_rule_ot_defaults_all
1711: where project_id = x_proj_id
1712: AND TASK_ID = x_task_id)
1713: or exists (SELECT NULL
1714: FROM pa_org_labor_sch_rule
1715: where overtime_project_id = x_proj_id
1716: AND overtime_TASK_ID = x_task_id);
1717: c3_rec c3%rowtype;
1718: