APPS.PAY_ES_BAL_UPLOAD dependencies on PAY_LEGISLATION_RULES

Line 32: FROM pay_legislation_rules

28: ,p_original_entry_id NUMBER) RETURN DATE IS
29: -- Returns the legislative start date
30: CURSOR csr_tax_start_date IS
31: SELECT rule_mode
32: FROM pay_legislation_rules
33: WHERE legislation_code ='ES'
34: AND rule_type = 'L';
35: -- Holds the legislative start date
36: l_leg_start pay_legislation_rules.rule_mode%TYPE;

Line 36: l_leg_start pay_legislation_rules.rule_mode%TYPE;

32: FROM pay_legislation_rules
33: WHERE legislation_code ='ES'
34: AND rule_type = 'L';
35: -- Holds the legislative start date
36: l_leg_start pay_legislation_rules.rule_mode%TYPE;
37: -- Returns the start date of the first period of the tax year in which
38: -- the upload date falls.
39: -- 1) to_char(to_date(p_upload_date,'DD/MM/YYYY'),'YYYY')
40: -- retuned incorrect output depening on the date setting