DBA Data[Home] [Help]

APPS.PAY_PBF_BUS dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 805: pay_element_classifications ec

801: SELECT 1
802: FROM pay_balance_feeds_f blf,
803: pay_input_values_f inv,
804: pay_element_types_f elt,
805: pay_element_classifications ec
806: WHERE blf.balance_type_id = p_balance_type_id
807: AND blf.input_value_id = inv.input_value_id
808: AND inv.element_type_id = elt.element_type_id
809: AND nvl(elt.legislation_code

Line 1643: pay_element_classifications ec

1639: cursor csr_balance_init_flag is
1640: SELECT 1
1641: FROM pay_input_values_f inv,
1642: pay_element_types_f elt,
1643: pay_element_classifications ec
1644: WHERE inv.input_value_id = p_input_value_id
1645: AND inv.element_type_id = elt.element_type_id
1646: AND elt.classification_id = ec.classification_id
1647: AND ec.balance_initialization_flag = 'Y';