[Home] [Help]
147: ,peevf.screen_entry_value
148: from pay_element_entries_f peef
149: ,pay_element_types_f petf
150: ,pay_element_entry_values_f peevf
151: ,pay_input_values_f pivf
152: ,pay_status_processing_rules_f psprf
153: ,ff_formulas_f fff
154: ,pay_element_classifications pec
155: where peef.element_entry_id = p_element_entry_id
284: where element_entry_value_id =
285: (select distinct peev1.element_entry_value_id
286: from pay_element_entry_values_f peev1,
287: pay_element_entries_f peef,
288: pay_input_values_f pivf
289: where peef.element_entry_id = p_element_entry_id
290: and pivf.element_type_id = peef.element_type_id
291: and upper(pivf.name) = 'EARNED START DATE'
292: and peev1.element_entry_id = peef.element_entry_id
299: where element_entry_value_id =
300: (select distinct peev1.element_entry_value_id
301: from pay_element_entry_values_f peev1,
302: pay_element_entries_f peef,
303: pay_input_values_f pivf
304: where peef.element_entry_id = p_element_entry_id
305: and pivf.element_type_id = peef.element_type_id
306: and upper(pivf.name) = 'EARNED END DATE'
307: and peev1.element_entry_id = peef.element_entry_id
713: ,c_effective_date date) is
714: select pivf.name
715: ,peev.screen_entry_value
716: ,pivf.lookup_type
717: from pay_input_values_f pivf
718: ,pay_element_entry_values_f peev
719: where peev.element_entry_id = c_element_entry_id
720: and peev.input_value_id = pivf.input_value_id
721: and c_effective_date between peev.effective_start_date
731: select petf.element_type_id
732: ,pivf.input_value_id
733: ,pivf.name
734: from pay_element_types_f petf
735: ,pay_input_values_f pivf
736: where petf.element_name like c_element_name || ' for FLSA Calc'
737: and petf.business_group_id = c_business_grp_id
738: and pivf.element_type_id = petf.element_type_id
739: and c_efective_start_date between pivf.effective_start_date
1049: c_effective_date date) is
1050: select rtrim(ltrim(peev.screen_entry_value))
1051: from pay_element_entry_values_f peev
1052: ,pay_element_entries_f peef
1053: ,pay_input_values_f pivf
1054: where peef.element_entry_id = c_element_entry_id
1055: and pivf.element_type_id = peef.element_type_id
1056: and upper(pivf.name) = 'JURISDICTION'
1057: and peev.element_entry_id = peef.element_entry_id
1371: cursor c_get_rate_entry_count(c_element_entry_id number
1372: ,c_effective_date date) is
1373: select count(peev.screen_entry_value)
1374: from pay_element_entries_f peef,
1375: pay_input_values_f pivf,
1376: pay_element_entry_values_f peev
1377: where peef.element_entry_id = c_element_entry_id
1378: and pivf.element_type_id = peef.element_type_id
1379: and pivf.name in ('Rate', 'Rate Code')
1506: c_effective_date date) is
1507: select peev.screen_entry_value
1508: from pay_element_entry_values_f peev
1509: ,pay_element_entries_f peef
1510: ,pay_input_values_f pivf
1511: where peef.element_entry_id = c_element_entry_id
1512: and peev.element_entry_id = peef.element_entry_id
1513: and pivf.element_type_id = peef.element_type_id
1514: and upper(pivf.name) = upper(c_inp_value_name)
1525: ,c_business_group_id number) is
1526: select distinct
1527: pivf.input_value_id
1528: from pay_element_types_f petf
1529: ,pay_input_values_f pivf
1530: where petf.element_name = c_element_name
1531: and petf.business_group_id = c_business_group_id
1532: and pivf.element_type_id = petf.element_type_id
1533: and pivf.name = c_inp_val_name;
1917: ,peef.effective_end_date
1918: ,peev.screen_entry_value
1919: from pay_element_entries_f peef,
1920: pay_element_entry_values_f peev,
1921: pay_input_values_f pivf
1922: where peef.creator_id = c_element_entry_id
1923: and peef.assignment_id = c_assignment_id
1924: and peef.creator_type = 'FL'
1925: and peev.element_entry_id = peef.element_entry_id
1937: select pivf.name
1938: ,peevf.screen_entry_value
1939: from pay_element_entries_f peef
1940: ,pay_element_entry_values_f peevf
1941: ,pay_input_values_f pivf
1942: where peef.element_entry_id = c_element_entry_id
1943: and peevf.element_entry_id = peef.element_entry_id
1944: and pivf.element_type_id = peef.element_type_id
1945: and peevf.input_value_id = pivf.input_value_id
1957: cursor c_get_inp_value_id (c_element_name varchar2
1958: ,c_business_group_id number) is
1959: select pivf.input_value_id
1960: from pay_element_types_f petf,
1961: pay_input_values_f pivf
1962: where petf.element_name = c_element_name || ' for FLSA Calc'
1963: and petf.business_group_id = c_business_group_id
1964: and pivf.element_type_id = petf.element_type_id
1965: and upper(pivf.name) = 'DAILY AMOUNT';
2189: cursor c_get_rate_entry_count(c_element_entry_id number
2190: ,c_effective_date date) is
2191: select count(peev.screen_entry_value)
2192: from pay_element_entries_f peef,
2193: pay_input_values_f pivf,
2194: pay_element_entry_values_f peev
2195: where peef.element_entry_id = c_element_entry_id
2196: and pivf.element_type_id = peef.element_type_id
2197: and pivf.name in ('Rate', 'Rate Code')
2263: c_effective_date date) is
2264: select peev.screen_entry_value
2265: from pay_element_entry_values_f peev
2266: ,pay_element_entries_f peef
2267: ,pay_input_values_f pivf
2268: where peef.element_entry_id = c_element_entry_id
2269: and peev.element_entry_id = peef.element_entry_id
2270: and pivf.element_type_id = peef.element_type_id
2271: and upper(pivf.name) = upper(c_inp_value_name)
2294: ,c_business_group_id number) is
2295: select distinct
2296: pivf.input_value_id
2297: from pay_element_types_f petf
2298: ,pay_input_values_f pivf
2299: where petf.element_name = c_element_name
2300: and petf.business_group_id = c_business_group_id
2301: and pivf.element_type_id = petf.element_type_id
2302: and pivf.name = c_inp_val_name;