[Home] [Help]
823: SELECT 1
824: FROM pay_balance_feeds_f blf,
825: pay_input_values_f inv,
826: pay_element_types_f elt,
827: pay_element_classifications ec
828: WHERE blf.balance_type_id = p_balance_type_id
829: AND blf.input_value_id = inv.input_value_id
830: AND inv.element_type_id = elt.element_type_id
831: AND nvl(elt.legislation_code
1682: cursor csr_balance_init_flag is
1683: SELECT 1
1684: FROM pay_input_values_f inv,
1685: pay_element_types_f elt,
1686: pay_element_classifications ec
1687: WHERE inv.input_value_id = p_input_value_id
1688: AND inv.element_type_id = elt.element_type_id
1689: AND elt.classification_id = ec.classification_id
1690: AND ec.balance_initialization_flag = 'Y';