[Home] [Help]
220: iv.last_updated_by a_last_updated_by,
221: iv.last_update_login a_last_update_login,
222: iv.created_by a_created_by
223: FROM pay_balance_types bt,
224: pay_balance_classifications bc,
225: pay_element_types_f et,
226: pay_input_values_f iv
227: WHERE iv.input_value_id = p_input_value_id
228: AND et.element_type_id = iv.element_type_id
243: CURSOR cur_check_pay_pay_value IS
244: SELECT feed.balance_feed_id
245: FROM pay_balance_feeds_f feed,
246: pay_balance_types bt,
247: pay_balance_classifications bc,
248: pay_element_types_f et,
249: pay_input_values_f iv
250: WHERE iv.input_value_id = p_input_value_id
251: AND et.element_type_id = iv.element_type_id
280: iv.last_updated_by a_last_updated_by,
281: iv.last_update_login a_last_update_login,
282: iv.created_by a_created_by
283: FROM pay_balance_types bt,
284: pay_balance_classifications bc,
285: pay_element_types_f et,
286: pay_input_values_f iv
287: WHERE iv.input_value_id = p_input_value_id
288: AND et.element_type_id = iv.element_type_id
303: CURSOR cur_check_per_pay_value_prim IS
304: SELECT feed.balance_feed_id
305: FROM pay_balance_feeds_f feed,
306: pay_balance_types bt,
307: pay_balance_classifications bc,
308: pay_element_types_f et,
309: pay_input_values_f iv
310: WHERE iv.input_value_id = p_input_value_id
311: AND et.element_type_id = iv.element_type_id
340: iv.last_updated_by a_last_updated_by,
341: iv.last_update_login a_last_update_login,
342: iv.created_by a_created_by
343: FROM pay_balance_types bt,
344: pay_balance_classifications bc,
345: pay_element_types_f et,
346: pay_sub_classification_rules_f scr,
347: pay_input_values_f iv
348: WHERE iv.input_value_id = p_input_value_id
367: CURSOR cur_check_per_pay_value_sub IS
368: SELECT feed.balance_feed_id
369: FROM pay_balance_feeds_f feed,
370: pay_balance_types bt,
371: pay_balance_classifications bc,
372: pay_element_types_f et,
373: pay_sub_classification_rules_f scr,
374: pay_input_values_f iv
375: WHERE iv.input_value_id = p_input_value_id
437: scr.sub_classification_rule_id,
438: bc.balance_classification_id,
439: bt.balance_type_id
440: FROM pay_balance_types bt,
441: pay_balance_classifications bc,
442: pay_element_types_f et,
443: pay_input_values_f_tl iv_tl,
444: pay_input_values_f iv,
445: pay_sub_classification_rules_f scr
469: CURSOR cur_check_sub_class_rule IS
470: SELECT feed.balance_feed_id
471: FROM pay_balance_feeds feed,
472: pay_balance_types bt,
473: pay_balance_classifications bc,
474: pay_element_types_f et,
475: pay_input_values_f_tl iv_tl,
476: pay_input_values_f iv,
477: pay_sub_classification_rules_f scr
538: bc.last_updated_by a_last_updated_by,
539: bc.last_update_login a_last_update_login,
540: bc.created_by a_created_by
541: FROM pay_balance_types bt,
542: pay_balance_classifications bc,
543: pay_sub_classification_rules_f scr
544: WHERE scr.sub_classification_rule_id
545: = p_sub_classification_rule_id
546: AND bc.classification_id = scr.classification_id
1615: and userenv('LANG') = b_tl.language
1616: and b.balance_type_id = p_balance_type_id
1617: and exists
1618: (select 1
1619: from pay_balance_classifications bc
1620: where b.balance_type_id = bc.balance_type_id);
1621: --
1622: exception
1623: when NO_DATA_FOUND then NULL;
1798: AND KEY_VALUE IN
1799: (SELECT feed.balance_feed_id
1800: FROM pay_balance_feeds_f feed,
1801: pay_input_values_f iv,
1802: pay_balance_classifications bc
1803: WHERE iv.element_type_id = p_element_type_id
1804: AND iv.name = 'Pay Value'
1805: AND feed.input_value_id = iv.input_value_id
1806: AND bc.classification_id
1813: WHERE balance_feed_id in
1814: (SELECT feed.balance_feed_id
1815: FROM pay_balance_feeds_f feed,
1816: pay_input_values_f iv,
1817: pay_balance_classifications bc
1818: WHERE iv.element_type_id = p_element_type_id
1819: AND iv.name = 'Pay Value'
1820: AND feed.input_value_id = iv.input_value_id
1821: AND bc.classification_id
1831: WHERE balance_feed_id in
1832: (SELECT feed.balance_feed_id
1833: FROM pay_balance_feeds_f feed,
1834: pay_input_values_f iv,
1835: pay_balance_classifications bc
1836: WHERE iv.element_type_id = p_element_type_id
1837: AND iv.name = 'Pay Value'
1838: AND feed.input_value_id = iv.input_value_id
1839: AND bc.classification_id
1847: WHERE balance_feed_id in
1848: (SELECT feed.balance_feed_id
1849: FROM pay_balance_feeds_f feed,
1850: pay_input_values_f iv,
1851: pay_balance_classifications bc
1852: WHERE iv.element_type_id = p_element_type_id
1853: AND iv.name = 'Pay Value'
1854: AND feed.input_value_id = iv.input_value_id
1855: AND bc.classification_id
1867: WHERE balance_feed_id in
1868: (SELECT feed.balance_feed_id
1869: FROM pay_balance_feeds_f feed,
1870: pay_input_values_f iv,
1871: pay_balance_classifications bc
1872: WHERE iv.element_type_id = p_element_type_id
1873: AND iv.name = 'Pay Value'
1874: AND feed.input_value_id = iv.input_value_id
1875: AND bc.classification_id
1883: WHERE balance_feed_id in
1884: (SELECT feed.balance_feed_id
1885: FROM pay_balance_feeds_f feed,
1886: pay_input_values_f iv,
1887: pay_balance_classifications bc
1888: WHERE iv.element_type_id = p_element_type_id
1889: AND iv.name = 'Pay Value'
1890: AND feed.input_value_id = iv.input_value_id
1891: AND bc.classification_id
2069: WHERE defined_balance_id = each_def_bal.defined_balance_id;
2070: --
2071: end loop;
2072: --
2073: DELETE FROM pay_balance_classifications
2074: WHERE balance_type_id = p_balance_type_id;
2075: --
2076: IF p_mode <> 'USER' THEN
2077: DELETE FROM hr_application_ownerships