DBA Data[Home] [Help]

APPS.PAY_BALANCE_UPLOAD dependencies on PAY_ELEMENT_TYPES_F

Line 2098: pay_element_types_f pet,

2094: CURSOR WCB_input_value(p_inp_name varchar2)
2095: IS
2096: select peev.screen_entry_value
2097: from pay_element_entries_f pee,
2098: pay_element_types_f pet,
2099: pay_element_entry_values_f peev,
2100: pay_input_values_f piv
2101: where pee.assignment_id = p_asg_id
2102: and pet.element_name = 'WCB'

Line 4539: ,pay_element_types_f ET

4535: from pay_balance_types BT
4536: ,pay_balance_feeds_f BF
4537: ,pay_input_values_f IV
4538: ,pay_input_values_f IV2
4539: ,pay_element_types_f ET
4540: ,pay_element_classifications EC
4541: where BF.balance_type_id = p_balance_type_id
4542: and BT.balance_type_id = BF.balance_type_id
4543: and IV.input_value_id = BF.input_value_id