APPS.PAY_US_ITERATIVE_VALUES dependencies on PAY_TAXABILITY_RULES

Line 653: from pay_taxability_rules_dates

649: and pec.classification_name = 'Involuntary Deductions';
650:
651: CURSOR csr_get_info is
652: select taxability_rules_date_id
653: from pay_taxability_rules_dates
654: where p_date_earned between valid_date_from and
655: valid_date_to
656: and legislation_code = 'US';
657:

Line 661: p_tax_cat pay_taxability_rules.tax_category%TYPE,

657:
658:
659: CURSOR csr_tax_rules_exists(
660: p_juri_code VARCHAR2,
661: p_tax_cat pay_taxability_rules.tax_category%TYPE,
662: p_classification_id pay_element_classifications.classification_id%TYPE,
663: p_tax_rules_date_id pay_taxability_rules.taxability_rules_date_id%TYPE
664: ) is
665: select 'Y'

Line 663: p_tax_rules_date_id pay_taxability_rules.taxability_rules_date_id%TYPE

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

Line 666: from pay_taxability_rules

662: p_classification_id pay_element_classifications.classification_id%TYPE,
663: p_tax_rules_date_id pay_taxability_rules.taxability_rules_date_id%TYPE
664: ) is
665: select 'Y'
666: from pay_taxability_rules
667: where jurisdiction_code = p_juri_code
668: and tax_type = p_tax_type
669: and tax_category = p_tax_cat
670: and classification_id = p_classification_id

Line 700: l_tax_rules_date_id pay_taxability_rules_dates.taxability_rules_date_id%TYPE;

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