APPS.PQP_CPYTAXRUL dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 7: p_classification_name IN pay_element_classifications.classification_name%type,

3:
4: PROCEDURE COPY_TAX_RULES (
5: errbuf OUT NOCOPY VARCHAR2,
6: retcode OUT NOCOPY NUMBER,
7: p_classification_name IN pay_element_classifications.classification_name%type,
8: p_source_category IN pay_taxability_rules.tax_category%type,
9: p_target_category IN pay_taxability_rules.tax_category%type,
10: p_source_state_code IN pay_us_states.state_code%type,
11: p_target_state_code IN pay_us_states.state_code%type

Line 15: l_classification_id pay_element_classifications.classification_id%type;

11: p_target_state_code IN pay_us_states.state_code%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;

Line 27: from pay_element_classifications pec

23: -- rules are defined for the 3 classifications
24:
25: cursor c_classification_id is
26: select classification_id
27: from pay_element_classifications pec
28: where pec.classification_name = p_classification_name
29: and pec.legislation_code = 'US'
30: and p_classification_name in
31: ('Supplemental Earnings','Imputed Earnings','Pre-Tax Deductions');