DBA Data[Home] [Help]

APPS.PA_PROJ_TSK_UTILS dependencies on PA_JOB_BILL_RATE_OVERRIDES

Line 1931: FROM PA_JOB_BILL_RATE_OVERRIDES

1927: cursor c1 is
1928: SELECT 1
1929: FROM sys.dual
1930: where exists (SELECT NULL
1931: FROM PA_JOB_BILL_RATE_OVERRIDES
1932: WHERE project_id = x_project_id
1933: and task_id is null);
1934:
1935: cursor c2 is

Line 1939: FROM PA_JOB_BILL_RATE_OVERRIDES

1935: cursor c2 is
1936: SELECT 1
1937: FROM sys.dual
1938: where exists (SELECT NULL
1939: FROM PA_JOB_BILL_RATE_OVERRIDES
1940: WHERE TASK_ID = x_task_ID);
1941:
1942: c1_rec c1%rowtype;
1943: c2_rec c2%rowtype;

Line 2061: -- instead of PA_JOB_BILL_RATE_OVERRIDES

2057: --
2058: -- HISTORY
2059: -- 20-OCT-95 R. Chiu Created
2060: -- 05-SEP-02 GJAIN For bug 2550288 changed cursor c2 to refer PA_EMP_BILL_RATE_OVERRIDES
2061: -- instead of PA_JOB_BILL_RATE_OVERRIDES
2062: --
2063: function check_emp_bill_rate_override (x_project_id IN number
2064: , x_task_id IN number ) return number
2065: is

Line 2073: /* bug 2550288 changed below cursor to refer PA_EMP_BILL_RATE_OVERRIDES instead of PA_JOB_BILL_RATE_OVERRIDES */

2069: where exists (SELECT NULL
2070: FROM PA_EMP_BILL_RATE_OVERRIDES
2071: WHERE project_id = x_project_id);
2072:
2073: /* bug 2550288 changed below cursor to refer PA_EMP_BILL_RATE_OVERRIDES instead of PA_JOB_BILL_RATE_OVERRIDES */
2074: cursor c2 is
2075: SELECT 1
2076: FROM sys.dual
2077: where exists (SELECT NULL