[Home] [Help]
13: FROM per_all_people_f p, per_all_assignments_f a
14: WHERE a.person_id=p.person_id AND a.assignment_id=p_assgt_id;
15: IF prsa2 = 0 THEN
16: SELECT i.value INTO l_percent
17: FROM pay_user_tables t, pay_user_columns c, pay_user_rows_f r, pay_user_column_instances_f i
18: WHERE t.user_table_name = 'IE PRSA Certificate Rates'
19: AND t.user_table_id=c.user_table_id
20: AND t.user_table_id=r.user_table_id
21: AND i.user_column_id=c.user_column_id
25: AND p_date_earned BETWEEN r.effective_start_date AND r.effective_end_date
26: AND p_date_earned BETWEEN i.effective_start_date AND i.effective_end_date;
27: ELSE
28: SELECT i.value INTO l_percent
29: FROM pay_user_tables t, pay_user_columns c, pay_user_rows_f r, pay_user_column_instances_f i
30: WHERE t.user_table_name = 'IE PRSA Certificate Rates'
31: AND t.user_table_id=c.user_table_id
32: AND t.user_table_id=r.user_table_id
33: AND i.user_column_id=c.user_column_id
94: l_percent number;
95: BEGIN
96: IF prsa2 = 0 THEN
97: SELECT i.value INTO l_percent
98: FROM pay_user_tables t, pay_user_columns c, pay_user_rows_f r, pay_user_column_instances_f i
99: WHERE t.user_table_name = 'IE PRSA Certificate Rates'
100: AND t.user_table_id=c.user_table_id
101: AND t.user_table_id=r.user_table_id
102: AND i.user_column_id=c.user_column_id
106: AND p_date_earned BETWEEN r.effective_start_date AND r.effective_end_date
107: AND p_date_earned BETWEEN i.effective_start_date AND i.effective_end_date;
108: ELSE
109: SELECT i.value INTO l_percent
110: FROM pay_user_tables t, pay_user_columns c, pay_user_rows_f r, pay_user_column_instances_f i
111: WHERE t.user_table_name = 'IE PRSA Certificate Rates'
112: AND t.user_table_id=c.user_table_id
113: AND t.user_table_id=r.user_table_id
114: AND i.user_column_id=c.user_column_id