DBA Data[Home] [Help]

APPS.PAY_IN_FORM_24Q_WEB_ADI dependencies on PAY_ELEMENT_TYPES_F

Line 856: , pay_element_types_f types

852: SELECT types.element_type_id
853: ,link.element_link_id
854: FROM per_assignments_f assgn
855: , pay_element_links_f link
856: , pay_element_types_f types
857: WHERE assgn.assignment_id = p_assignment_id
858: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id
859: ,p_pre_payment_date
860: ,types.element_type_id

Line 877: FROM pay_element_types_f types

873: )
874: IS
875: SELECT inputs.name name
876: , inputs.input_value_id id
877: FROM pay_element_types_f types
878: , pay_input_values_f inputs
879: WHERE types.element_type_id = p_element_type_id
880: AND inputs.element_type_id = types.element_type_id
881: AND inputs.legislation_code = 'IN'