[Home] [Help]
131: ,peevf.screen_entry_value
132: from pay_element_entries_f peef
133: ,pay_element_types_f petf
134: ,pay_element_entry_values_f peevf
135: ,pay_input_values_f pivf
136: ,pay_status_processing_rules_f psprf
137: ,ff_formulas_f fff
138: ,pay_element_classifications pec
139: where peef.element_entry_id = p_element_entry_id
268: where element_entry_value_id =
269: (select distinct peev1.element_entry_value_id
270: from pay_element_entry_values_f peev1,
271: pay_element_entries_f peef,
272: pay_input_values_f pivf
273: where peef.element_entry_id = p_element_entry_id
274: and pivf.element_type_id = peef.element_type_id
275: and upper(pivf.name) = 'EARNED START DATE'
276: and peev1.element_entry_id = peef.element_entry_id
283: where element_entry_value_id =
284: (select distinct peev1.element_entry_value_id
285: from pay_element_entry_values_f peev1,
286: pay_element_entries_f peef,
287: pay_input_values_f pivf
288: where peef.element_entry_id = p_element_entry_id
289: and pivf.element_type_id = peef.element_type_id
290: and upper(pivf.name) = 'EARNED END DATE'
291: and peev1.element_entry_id = peef.element_entry_id
685: ,c_effective_date date) is
686: select pivf.name
687: ,peev.screen_entry_value
688: ,pivf.lookup_type
689: from pay_input_values_f pivf
690: ,pay_element_entry_values_f peev
691: where peev.element_entry_id = c_element_entry_id
692: and peev.input_value_id = pivf.input_value_id
693: and c_effective_date between peev.effective_start_date
703: select petf.element_type_id
704: ,pivf.input_value_id
705: ,pivf.name
706: from pay_element_types_f petf
707: ,pay_input_values_f pivf
708: where petf.element_name like c_element_name || ' for FLSA Calc'
709: and petf.business_group_id = c_business_grp_id
710: and pivf.element_type_id = petf.element_type_id
711: and c_efective_start_date between pivf.effective_start_date
1021: c_effective_date date) is
1022: select rtrim(ltrim(peev.screen_entry_value))
1023: from pay_element_entry_values_f peev
1024: ,pay_element_entries_f peef
1025: ,pay_input_values_f pivf
1026: where peef.element_entry_id = c_element_entry_id
1027: and pivf.element_type_id = peef.element_type_id
1028: and upper(pivf.name) = 'JURISDICTION'
1029: and peev.element_entry_id = peef.element_entry_id
1285: cursor c_get_rate_entry_count(c_element_entry_id number
1286: ,c_effective_date date) is
1287: select count(peev.screen_entry_value)
1288: from pay_element_entries_f peef,
1289: pay_input_values_f pivf,
1290: pay_element_entry_values_f peev
1291: where peef.element_entry_id = c_element_entry_id
1292: and pivf.element_type_id = peef.element_type_id
1293: and pivf.name in ('Rate', 'Rate Code')
1408: c_effective_date date) is
1409: select peev.screen_entry_value
1410: from pay_element_entry_values_f peev
1411: ,pay_element_entries_f peef
1412: ,pay_input_values_f pivf
1413: where peef.element_entry_id = c_element_entry_id
1414: and peev.element_entry_id = peef.element_entry_id
1415: and pivf.element_type_id = peef.element_type_id
1416: and upper(pivf.name) = upper(c_inp_value_name)
1427: ,c_business_group_id number) is
1428: select distinct
1429: pivf.input_value_id
1430: from pay_element_types_f petf
1431: ,pay_input_values_f pivf
1432: where petf.element_name = c_element_name
1433: and petf.business_group_id = c_business_group_id
1434: and pivf.element_type_id = petf.element_type_id
1435: and pivf.name = c_inp_val_name;
1819: ,peef.effective_end_date
1820: ,peev.screen_entry_value
1821: from pay_element_entries_f peef,
1822: pay_element_entry_values_f peev,
1823: pay_input_values_f pivf
1824: where peef.creator_id = c_element_entry_id
1825: and peef.assignment_id = c_assignment_id
1826: and peef.creator_type = 'FL'
1827: and peev.element_entry_id = peef.element_entry_id
1839: select pivf.name
1840: ,peevf.screen_entry_value
1841: from pay_element_entries_f peef
1842: ,pay_element_entry_values_f peevf
1843: ,pay_input_values_f pivf
1844: where peef.element_entry_id = c_element_entry_id
1845: and peevf.element_entry_id = peef.element_entry_id
1846: and pivf.element_type_id = peef.element_type_id
1847: and peevf.input_value_id = pivf.input_value_id
1859: cursor c_get_inp_value_id (c_element_name varchar2
1860: ,c_business_group_id number) is
1861: select pivf.input_value_id
1862: from pay_element_types_f petf,
1863: pay_input_values_f pivf
1864: where petf.element_name = c_element_name || ' for FLSA Calc'
1865: and petf.business_group_id = c_business_group_id
1866: and pivf.element_type_id = petf.element_type_id
1867: and upper(pivf.name) = 'DAILY AMOUNT';
2091: cursor c_get_rate_entry_count(c_element_entry_id number
2092: ,c_effective_date date) is
2093: select count(peev.screen_entry_value)
2094: from pay_element_entries_f peef,
2095: pay_input_values_f pivf,
2096: pay_element_entry_values_f peev
2097: where peef.element_entry_id = c_element_entry_id
2098: and pivf.element_type_id = peef.element_type_id
2099: and pivf.name in ('Rate', 'Rate Code')
2165: c_effective_date date) is
2166: select peev.screen_entry_value
2167: from pay_element_entry_values_f peev
2168: ,pay_element_entries_f peef
2169: ,pay_input_values_f pivf
2170: where peef.element_entry_id = c_element_entry_id
2171: and peev.element_entry_id = peef.element_entry_id
2172: and pivf.element_type_id = peef.element_type_id
2173: and upper(pivf.name) = upper(c_inp_value_name)
2196: ,c_business_group_id number) is
2197: select distinct
2198: pivf.input_value_id
2199: from pay_element_types_f petf
2200: ,pay_input_values_f pivf
2201: where petf.element_name = c_element_name
2202: and petf.business_group_id = c_business_group_id
2203: and pivf.element_type_id = petf.element_type_id
2204: and pivf.name = c_inp_val_name;