eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BILLING_SCHEDULE_UTILS dependencies on PA_LOOKUPS

Line 38: FROM pa_std_bill_rate_schedules brs, pa_lookups l

34:
35: CURSOR c_ids
36: IS
37: SELECT brs.bill_rate_sch_id
38: FROM pa_std_bill_rate_schedules brs, pa_lookups l
39: WHERE brs.schedule_type = 'EMPLOYEE'
40: AND brs.std_bill_rate_schedule = p_emp_bill_rate_name
41: AND l.lookup_type = 'SCHEDULE TYPE'
42: AND l.lookup_code (+) = brs.schedule_type;

Line 52: FROM pa_std_bill_rate_schedules brs, pa_lookups l

48: IF p_check_id_flag = 'Y'
49: THEN
50: SELECT brs.bill_rate_sch_id
51: INTO x_emp_bill_rate_id
52: FROM pa_std_bill_rate_schedules brs, pa_lookups l
53: WHERE brs.schedule_type = 'EMPLOYEE'
54: AND brs.bill_rate_sch_id = p_emp_bill_rate_id
55: AND l.lookup_type = 'SCHEDULE TYPE'
56: AND l.lookup_code (+) = brs.schedule_type;

Line 96: FROM pa_std_bill_rate_schedules brs, pa_lookups l

92: IF p_emp_bill_rate_name IS NOT NULL
93: THEN
94: SELECT brs.bill_rate_sch_id
95: INTO x_emp_bill_rate_id
96: FROM pa_std_bill_rate_schedules brs, pa_lookups l
97: WHERE brs.schedule_type = 'EMPLOYEE'
98: AND brs.std_bill_rate_schedule = p_emp_bill_rate_name
99: AND l.lookup_type = 'SCHEDULE TYPE'
100: AND l.lookup_code (+) = brs.schedule_type;

Line 157: FROM pa_std_bill_rate_schedules brs, pa_lookups l

153:
154: CURSOR c_ids
155: IS
156: SELECT brs.bill_rate_sch_id
157: FROM pa_std_bill_rate_schedules brs, pa_lookups l
158: WHERE brs.schedule_type = 'JOB'
159: AND brs.std_bill_rate_schedule = p_job_bill_rate_name
160: AND brs.job_group_id = p_job_group_id
161: AND l.lookup_type = 'SCHEDULE TYPE'

Line 172: FROM pa_std_bill_rate_schedules brs, pa_lookups l

168: IF p_check_id_flag = 'Y'
169: THEN
170: SELECT brs.bill_rate_sch_id
171: INTO x_job_bill_rate_id
172: FROM pa_std_bill_rate_schedules brs, pa_lookups l
173: WHERE brs.schedule_type = 'JOB'
174: AND brs.bill_rate_sch_id = p_job_bill_rate_id
175: AND brs.job_group_id = p_job_group_id
176: AND l.lookup_type = 'SCHEDULE TYPE'

Line 217: FROM pa_std_bill_rate_schedules brs, pa_lookups l

213: IF p_job_bill_rate_name IS NOT NULL
214: THEN
215: SELECT brs.bill_rate_sch_id
216: INTO x_job_bill_rate_id
217: FROM pa_std_bill_rate_schedules brs, pa_lookups l
218: WHERE brs.schedule_type = 'JOB'
219: AND brs.std_bill_rate_schedule = p_job_bill_rate_name
220: AND brs.job_group_id = p_job_group_id
221: AND l.lookup_type = 'SCHEDULE TYPE'

Line 278: FROM pa_lookups l, pa_ind_rate_schedules irs

274:
275: CURSOR c_ids
276: IS
277: SELECT irs.ind_rate_sch_id
278: FROM pa_lookups l, pa_ind_rate_schedules irs
279: WHERE l.lookup_type = 'IND RATE SCHEDULE TYPE'
280: AND l.lookup_code = irs.ind_rate_schedule_type
281: AND irs.project_id IS NULL
282: AND trunc(sysdate) BETWEEN irs.start_date_active

Line 293: FROM pa_lookups l, pa_ind_rate_schedules irs

289: IF p_check_id_flag = 'Y'
290: THEN
291: SELECT irs.ind_rate_sch_id
292: INTO x_rev_sch_id
293: FROM pa_lookups l, pa_ind_rate_schedules irs
294: WHERE l.lookup_type = 'IND RATE SCHEDULE TYPE'
295: AND l.lookup_code = irs.ind_rate_schedule_type
296: AND irs.project_id IS NULL
297: AND trunc(sysdate) BETWEEN irs.start_date_active

Line 340: FROM pa_lookups l, pa_ind_rate_schedules irs

336: IF p_rev_sch_name IS NOT NULL
337: THEN
338: SELECT irs.ind_rate_sch_id
339: INTO x_rev_sch_id
340: FROM pa_lookups l, pa_ind_rate_schedules irs
341: WHERE l.lookup_type = 'IND RATE SCHEDULE TYPE'
342: AND l.lookup_code = irs.ind_rate_schedule_type
343: AND irs.project_id IS NULL
344: AND trunc(sysdate) BETWEEN irs.start_date_active

Line 402: FROM pa_lookups l, pa_ind_rate_schedules irs

398:
399: CURSOR c_ids
400: IS
401: SELECT irs.ind_rate_sch_id
402: FROM pa_lookups l, pa_ind_rate_schedules irs
403: WHERE l.lookup_type = 'IND RATE SCHEDULE TYPE'
404: AND l.lookup_code = irs.ind_rate_schedule_type
405: AND irs.project_id IS NULL
406: AND trunc(sysdate) BETWEEN irs.start_date_active

Line 417: FROM pa_lookups l, pa_ind_rate_schedules irs

413: IF p_check_id_flag = 'Y'
414: THEN
415: SELECT irs.ind_rate_sch_id
416: INTO x_inv_sch_id
417: FROM pa_lookups l, pa_ind_rate_schedules irs
418: WHERE l.lookup_type = 'IND RATE SCHEDULE TYPE'
419: AND l.lookup_code = irs.ind_rate_schedule_type
420: AND irs.project_id IS NULL
421: AND trunc(sysdate) BETWEEN irs.start_date_active

Line 464: FROM pa_lookups l, pa_ind_rate_schedules irs

460: IF p_inv_sch_name IS NOT NULL
461: THEN
462: SELECT irs.ind_rate_sch_id
463: INTO x_inv_sch_id
464: FROM pa_lookups l, pa_ind_rate_schedules irs
465: WHERE l.lookup_type = 'IND RATE SCHEDULE TYPE'
466: AND l.lookup_code = irs.ind_rate_schedule_type
467: AND irs.project_id IS NULL
468: AND trunc(sysdate) BETWEEN irs.start_date_active

Line 526: FROM pa_std_bill_rate_schedules brs, pa_lookups l

522: IF p_check_id_flag = 'Y'
523: THEN
524: SELECT brs.std_bill_rate_schedule
525: INTO x_sch_name
526: FROM pa_std_bill_rate_schedules brs, pa_lookups l
527: WHERE organization_id = p_nlbr_org_id
528: AND brs.schedule_type = 'NON-LABOR'
529: AND l.lookup_type = 'SCHEDULE TYPE'
530: AND l.lookup_code (+) = brs.schedule_type