DBA Data[Home] [Help]

APPS.PAY_US_TAXABILITY_RULES_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 79: on pay_element_types_f

75: that have been fed.
76: 23-sep-2003 asasthan 115.8 3152061 Changes to date joins
77: in get_balance_type
78: 23-sep-2003 asasthan 115.9 3152061 added chk for legislation
79: on pay_element_types_f
80: 23-sep-2003 asasthan 115.10 3152061 removed chk for legislation
81: on pay_element_types_f
82: 03-nov-2003 tclewis 115.11 2845480 Added code to handle AEIC.
83: state level box 6.

Line 81: on pay_element_types_f

77: in get_balance_type
78: 23-sep-2003 asasthan 115.9 3152061 added chk for legislation
79: on pay_element_types_f
80: 23-sep-2003 asasthan 115.10 3152061 removed chk for legislation
81: on pay_element_types_f
82: 03-nov-2003 tclewis 115.11 2845480 Added code to handle AEIC.
83: state level box 6.
84: 10-DEC-2003 tclewis 115.14 Changed tax type for AEIC to
85: STEIC from EIC.

Line 747: from pay_element_types_f pet

743: cp_trash_date in date) is
744: select 'Y' from dual
745: where exists (
746: select element_type_id
747: from pay_element_types_f pet
748: where pet.classification_id = cp_classification_id
749: and pet.element_information1 = cp_tax_category
750: and effective_end_date >= cp_trash_date
751: ) ;

Line 766: pay_element_types_f pet

762: and exists
763: ( select 1
764: from pay_balance_feeds_f pbf,
765: pay_input_values_f piv,
766: pay_element_types_f pet
767: where pbf.balance_type_id = pbt.balance_type_id
768: and pbf.effective_end_date >= cp_trash_date
769: and piv.input_value_id = pbf.input_value_id
770: and pbf.effective_start_date between piv.effective_start_date