APPS.PQP_CPYTAXRUL dependencies on PAY_TAXABILITY_RULES

Line 8: p_source_category IN pay_taxability_rules.tax_category%type,

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
12: )

Line 9: p_target_category IN pay_taxability_rules.tax_category%type,

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
12: )
13: IS

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 19: l_jsd_code pay_taxability_rules.jurisdiction_code%type;

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:
21: -- Cursor to get Classification Id. Assuming that the Script is
22: -- used only for US legislation and taxability and the wage attachment
23: -- rules are defined for the 3 classifications

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:

Line 44: cursor c_pay_taxability_rules is

40: and trd.legislation_code = 'US' ;
41:
42: --cursor to get Taxability Rules
43:
44: cursor c_pay_taxability_rules is
45: select jurisdiction_code,
46: tax_type,
47: status
48: from pay_taxability_rules ptr

Line 48: from pay_taxability_rules ptr

44: cursor c_pay_taxability_rules is
45: select jurisdiction_code,
46: tax_type,
47: status
48: from pay_taxability_rules ptr
49: where ptr.classification_id = l_classification_id
50: and ptr.legislation_code = 'US'
51: and ptr.tax_category = p_source_category
52: and (ptr.jurisdiction_code like p_source_state_code||'%' or

Line 94: Delete pay_taxability_rules

90: else
91:
92: -- Delete the Taxability Rules if any for Target Category Code.
93:
94: Delete pay_taxability_rules
95: where classification_id = l_classification_id
96: and legislation_code = 'US'
97: and tax_category = p_target_category
98: and jurisdiction_code like p_target_state_code||'%' ;

Line 102: for tax_rul in c_pay_taxability_rules loop

98: and jurisdiction_code like p_target_state_code||'%' ;
99:
100: --Get Taxability Rules
101:
102: for tax_rul in c_pay_taxability_rules loop
103:
104: -- If the rules are to be copied from one state to other then
105: -- the jurisdiction code can be changed accordingly.
106:

Line 113: insert into pay_taxability_rules (jurisdiction_code,

109: else
110: l_jsd_code := p_target_state_code||substr(tax_rul.jurisdiction_code,3,9);
111: end if;
112:
113: insert into pay_taxability_rules (jurisdiction_code,
114: tax_type,
115: tax_category,
116: classification_id,
117: taxability_rules_date_id,