APPS.PAY_US_ITERATIVE_VALUES dependencies on PAY_TAXABILITY_RULES

Line 657: from pay_taxability_rules_dates

653: and pec.classification_name = 'Involuntary Deductions';
654:
655: CURSOR csr_get_info is
656: select taxability_rules_date_id
657: from pay_taxability_rules_dates
658: where p_date_earned between valid_date_from and
659: valid_date_to
660: and legislation_code = 'US';
661:

Line 665: p_tax_cat pay_taxability_rules.tax_category%TYPE,

661:
662:
663: CURSOR csr_tax_rules_exists(
664: p_juri_code VARCHAR2,
665: p_tax_cat pay_taxability_rules.tax_category%TYPE,
666: p_classification_id pay_element_classifications.classification_id%TYPE,
667: p_tax_rules_date_id pay_taxability_rules.taxability_rules_date_id%TYPE
668: ) is
669: select 'Y'

Line 667: p_tax_rules_date_id pay_taxability_rules.taxability_rules_date_id%TYPE

663: CURSOR csr_tax_rules_exists(
664: p_juri_code VARCHAR2,
665: p_tax_cat pay_taxability_rules.tax_category%TYPE,
666: p_classification_id pay_element_classifications.classification_id%TYPE,
667: p_tax_rules_date_id pay_taxability_rules.taxability_rules_date_id%TYPE
668: ) is
669: select 'Y'
670: from pay_taxability_rules
671: where jurisdiction_code = p_juri_code

Line 670: from pay_taxability_rules

666: p_classification_id pay_element_classifications.classification_id%TYPE,
667: p_tax_rules_date_id pay_taxability_rules.taxability_rules_date_id%TYPE
668: ) is
669: select 'Y'
670: from pay_taxability_rules
671: where jurisdiction_code = p_juri_code
672: and tax_type = p_tax_type
673: and tax_category = p_tax_cat
674: and classification_id = p_classification_id

Line 704: l_tax_rules_date_id pay_taxability_rules_dates.taxability_rules_date_id%TYPE;

700: l_cur_ele_tax_cat pay_element_types_f.element_information1%TYPE;
701: l_fed VARCHAR2(5);
702: l_state VARCHAR2(5);
703:
704: l_tax_rules_date_id pay_taxability_rules_dates.taxability_rules_date_id%TYPE;
705: l_classification_id pay_element_classifications.classification_id%TYPE;
706: l_element_name pay_element_types_f.element_name%TYPE;
707: l_ip_val_name pay_input_values_f.name%TYPE;
708: l_value pay_element_entry_values_f.screen_entry_value%TYPE;