APPS.PA_PROJ_TSK_UTILS dependencies on PA_EMP_BILL_RATE_OVERRIDES

Line 2060: -- 05-SEP-02 GJAIN For bug 2550288 changed cursor c2 to refer PA_EMP_BILL_RATE_OVERRIDES

2056: -- If Oracle error occured, Oracle error code is returned.
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

Line 2070: FROM PA_EMP_BILL_RATE_OVERRIDES

2066: cursor c1 is
2067: SELECT 1
2068: FROM sys.dual
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

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

Line 2078: FROM PA_EMP_BILL_RATE_OVERRIDES

2074: cursor c2 is
2075: SELECT 1
2076: FROM sys.dual
2077: where exists (SELECT NULL
2078: FROM PA_EMP_BILL_RATE_OVERRIDES
2079: WHERE TASK_ID = x_task_ID);
2080:
2081: c1_rec c1%rowtype;
2082: c2_rec c2%rowtype;