DBA Data[Home] [Help]

APPS.PA_PROJ_TSK_UTILS dependencies on PA_COMP_RULE_OT_DEFAULTS_ALL

Line 1658: FROM pa_comp_rule_ot_defaults_all -- Bug 4680097: pa_compensation_rule_sets

1654: cursor c1 is
1655: SELECT 1
1656: FROM sys.dual
1657: WHERE EXISTS (SELECT NULL
1658: FROM pa_comp_rule_ot_defaults_all -- Bug 4680097: pa_compensation_rule_sets
1659: WHERE project_id = x_project_id)
1660: UNION
1661: SELECT 1
1662: FROM sys.dual

Line 1671: FROM pa_comp_rule_ot_defaults_all -- Bug 4680097: pa_compensation_rule_sets

1667: cursor c2 is
1668: SELECT 1
1669: FROM sys.dual
1670: where exists (SELECT NULL
1671: FROM pa_comp_rule_ot_defaults_all -- Bug 4680097: pa_compensation_rule_sets
1672: where project_id = x_proj_id
1673: AND TASK_ID IN
1674: (SELECT TASK_ID
1675: FROM PA_TASKS

Line 1710: FROM pa_comp_rule_ot_defaults_all

1706: SELECT 1
1707: FROM sys.dual
1708: WHERE
1709: exists (SELECT NULL
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