APPS.PQP_CPYTAXRUL dependencies on PAY_TAXABILITY_RULES_DATES

Line 16: l_tax_rules_date_id pay_taxability_rules_dates.taxability_rules_date_id%type;

12: )
13: IS
14:
15: l_classification_id pay_element_classifications.classification_id%type;
16: l_tax_rules_date_id pay_taxability_rules_dates.taxability_rules_date_id%type;
17: l_lookup_type fnd_lookup_values.lookup_code%type ;
18: l_temp number(1) ;
19: l_jsd_code pay_taxability_rules.jurisdiction_code%type;
20:

Line 37: from pay_taxability_rules_dates trd

33: -- Cursor to get Taxability Rule id based on current date
34:
35: cursor c_taxability_rules_date_id is
36: select taxability_rules_date_id
37: from pay_taxability_rules_dates trd
38: where sysdate between trd.valid_date_from
39: and trd.valid_date_to
40: and trd.legislation_code = 'US' ;
41: