DBA Data[Home] [Help]

APPS.PAY_CA_ROE_EI_PKG dependencies on PAY_TAXABILITY_RULES

Line 231: FROM pay_taxability_rules_dates trd,

227: p_class_id NUMBER,
228: p_tax_cat VARCHAR2,
229: p_eff_date DATE) IS
230: SELECT 1
231: FROM pay_taxability_rules_dates trd,
232: pay_taxability_rules txr
233: WHERE txr.classification_id = p_class_id
234: AND txr.tax_type = 'EIM'
235: AND txr.tax_category = p_tax_cat

Line 232: pay_taxability_rules txr

228: p_tax_cat VARCHAR2,
229: p_eff_date DATE) IS
230: SELECT 1
231: FROM pay_taxability_rules_dates trd,
232: pay_taxability_rules txr
233: WHERE txr.classification_id = p_class_id
234: AND txr.tax_type = 'EIM'
235: AND txr.tax_category = p_tax_cat
236: AND trd.taxability_rules_date_id = txr.taxability_rules_date_id