APPS.PA_BILLING_SCHEDULE_UTILS dependencies on PA_STD_BILL_RATE_SCHEDULES

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 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