eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 436: FROM pay_element_classifications pec,

432:
433: CURSOR get_ele_class IS
434: SELECT pec1.classification_id,
435: pec1.classification_name
436: FROM pay_element_classifications pec,
437: pay_element_classifications pec1, -- Secondary classification
438: pay_element_types_f pet,
439: pay_sub_classification_rules_f psr
440: WHERE pet.classification_id = pec.classification_id

Line 437: pay_element_classifications pec1, -- Secondary classification

433: CURSOR get_ele_class IS
434: SELECT pec1.classification_id,
435: pec1.classification_name
436: FROM pay_element_classifications pec,
437: pay_element_classifications pec1, -- Secondary classification
438: pay_element_types_f pet,
439: pay_sub_classification_rules_f psr
440: WHERE pet.classification_id = pec.classification_id
441: AND pec.classification_id = pec1.parent_classification_id

Line 458: FROM pay_element_classifications pec

454: AND p_tax_type = 'ISR'
455: UNION
456: SELECT pec.classification_id,
457: pec.classification_name
458: FROM pay_element_classifications pec
459: WHERE UPPER(pec.classification_name) = UPPER(p_classification_name)
460: AND pec.legislation_code = 'MX'
461: AND pec.business_group_id IS NULL
462: AND pec.parent_classification_id IS NOT NULL

Line 472: l_classification_name pay_element_classifications.classification_name%TYPE;

468: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
469: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
470: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
471: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
472: l_classification_name pay_element_classifications.classification_name%TYPE;
473: l_classification_id NUMBER;
474: l_counter NUMBER;
475: l_proc_name VARCHAR2(100);
476: l_index NUMBER;

Line 601: FROM pay_element_classifications pec,

597:
598: CURSOR get_ele_class IS
599: SELECT pec1.classification_id,
600: pec1.classification_name
601: FROM pay_element_classifications pec,
602: pay_element_classifications pec1, -- Secondary classification
603: pay_element_types_f pet,
604: pay_sub_classification_rules_f psr
605: WHERE pet.classification_id = pec.classification_id

Line 602: pay_element_classifications pec1, -- Secondary classification

598: CURSOR get_ele_class IS
599: SELECT pec1.classification_id,
600: pec1.classification_name
601: FROM pay_element_classifications pec,
602: pay_element_classifications pec1, -- Secondary classification
603: pay_element_types_f pet,
604: pay_sub_classification_rules_f psr
605: WHERE pet.classification_id = pec.classification_id
606: AND pec.classification_id = pec1.parent_classification_id

Line 623: FROM pay_element_classifications pec

619: AND p_tax_type = 'ISR'
620: UNION
621: SELECT pec.classification_id,
622: pec.classification_name
623: FROM pay_element_classifications pec
624: WHERE UPPER(pec.classification_name) = UPPER(p_classification_name)
625: AND pec.legislation_code = 'MX'
626: AND pec.business_group_id IS NULL
627: AND pec.parent_classification_id IS NOT NULL

Line 637: l_classification_name pay_element_classifications.classification_name%type;

633: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%type;
634: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%type;
635: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%type;
636: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%type;
637: l_classification_name pay_element_classifications.classification_name%type;
638: l_classification_id NUMBER;
639: l_counter NUMBER;
640: l_proc_name VARCHAR2(100);
641: l_index NUMBER;

Line 766: FROM pay_element_classifications pec,

762:
763: CURSOR get_ele_class IS
764: SELECT pec1.classification_id,
765: pec1.classification_name
766: FROM pay_element_classifications pec,
767: pay_element_classifications pec1, -- Secondary classification
768: pay_element_types_f pet,
769: pay_sub_classification_rules_f psr
770: WHERE pet.classification_id = pec.classification_id

Line 767: pay_element_classifications pec1, -- Secondary classification

763: CURSOR get_ele_class IS
764: SELECT pec1.classification_id,
765: pec1.classification_name
766: FROM pay_element_classifications pec,
767: pay_element_classifications pec1, -- Secondary classification
768: pay_element_types_f pet,
769: pay_sub_classification_rules_f psr
770: WHERE pet.classification_id = pec.classification_id
771: AND pec.classification_id = pec1.parent_classification_id

Line 788: FROM pay_element_classifications pec

784: AND p_tax_type = 'ISR'
785: UNION
786: SELECT pec.classification_id,
787: pec.classification_name
788: FROM pay_element_classifications pec
789: WHERE UPPER(pec.classification_name) = UPPER(p_classification_name)
790: AND pec.legislation_code = 'MX'
791: AND pec.business_group_id IS NULL
792: AND pec.parent_classification_id IS NOT NULL

Line 802: l_classification_name pay_element_classifications.classification_name%TYPE;

798: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
799: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
800: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
801: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
802: l_classification_name pay_element_classifications.classification_name%TYPE;
803: l_classification_id NUMBER;
804: l_counter NUMBER;
805: l_proc_name VARCHAR2(100);
806: l_index NUMBER;