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.

APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 367: FROM pay_element_classifications pec,

363:
364: CURSOR get_ele_class IS
365: SELECT pec1.classification_id,
366: pec1.classification_name
367: FROM pay_element_classifications pec,
368: pay_element_classifications pec1, -- Secondary classification
369: pay_element_types_f pet,
370: pay_sub_classification_rules_f psr
371: WHERE pet.classification_id = pec.classification_id

Line 368: pay_element_classifications pec1, -- Secondary classification

364: CURSOR get_ele_class IS
365: SELECT pec1.classification_id,
366: pec1.classification_name
367: FROM pay_element_classifications pec,
368: pay_element_classifications pec1, -- Secondary classification
369: pay_element_types_f pet,
370: pay_sub_classification_rules_f psr
371: WHERE pet.classification_id = pec.classification_id
372: AND pec.classification_id = pec1.parent_classification_id

Line 389: FROM pay_element_classifications pec

385: AND p_tax_type = 'ISR'
386: UNION
387: SELECT pec.classification_id,
388: pec.classification_name
389: FROM pay_element_classifications pec
390: WHERE UPPER(pec.classification_name) = UPPER(p_classification_name)
391: AND pec.legislation_code = 'MX'
392: AND pec.business_group_id IS NULL
393: AND pec.parent_classification_id IS NOT NULL

Line 403: l_classification_name pay_element_classifications.classification_name%TYPE;

399: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
400: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
401: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
402: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
403: l_classification_name pay_element_classifications.classification_name%TYPE;
404: l_classification_id NUMBER;
405: l_counter NUMBER;
406: l_proc_name VARCHAR2(100);
407: l_index NUMBER;

Line 532: FROM pay_element_classifications pec,

528:
529: CURSOR get_ele_class IS
530: SELECT pec1.classification_id,
531: pec1.classification_name
532: FROM pay_element_classifications pec,
533: pay_element_classifications pec1, -- Secondary classification
534: pay_element_types_f pet,
535: pay_sub_classification_rules_f psr
536: WHERE pet.classification_id = pec.classification_id

Line 533: pay_element_classifications pec1, -- Secondary classification

529: CURSOR get_ele_class IS
530: SELECT pec1.classification_id,
531: pec1.classification_name
532: FROM pay_element_classifications pec,
533: pay_element_classifications pec1, -- Secondary classification
534: pay_element_types_f pet,
535: pay_sub_classification_rules_f psr
536: WHERE pet.classification_id = pec.classification_id
537: AND pec.classification_id = pec1.parent_classification_id

Line 554: FROM pay_element_classifications pec

550: AND p_tax_type = 'ISR'
551: UNION
552: SELECT pec.classification_id,
553: pec.classification_name
554: FROM pay_element_classifications pec
555: WHERE UPPER(pec.classification_name) = UPPER(p_classification_name)
556: AND pec.legislation_code = 'MX'
557: AND pec.business_group_id IS NULL
558: AND pec.parent_classification_id IS NOT NULL

Line 568: l_classification_name pay_element_classifications.classification_name%type;

564: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%type;
565: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%type;
566: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%type;
567: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%type;
568: l_classification_name pay_element_classifications.classification_name%type;
569: l_classification_id NUMBER;
570: l_counter NUMBER;
571: l_proc_name VARCHAR2(100);
572: l_index NUMBER;

Line 697: FROM pay_element_classifications pec,

693:
694: CURSOR get_ele_class IS
695: SELECT pec1.classification_id,
696: pec1.classification_name
697: FROM pay_element_classifications pec,
698: pay_element_classifications pec1, -- Secondary classification
699: pay_element_types_f pet,
700: pay_sub_classification_rules_f psr
701: WHERE pet.classification_id = pec.classification_id

Line 698: pay_element_classifications pec1, -- Secondary classification

694: CURSOR get_ele_class IS
695: SELECT pec1.classification_id,
696: pec1.classification_name
697: FROM pay_element_classifications pec,
698: pay_element_classifications pec1, -- Secondary classification
699: pay_element_types_f pet,
700: pay_sub_classification_rules_f psr
701: WHERE pet.classification_id = pec.classification_id
702: AND pec.classification_id = pec1.parent_classification_id

Line 719: FROM pay_element_classifications pec

715: AND p_tax_type = 'ISR'
716: UNION
717: SELECT pec.classification_id,
718: pec.classification_name
719: FROM pay_element_classifications pec
720: WHERE UPPER(pec.classification_name) = UPPER(p_classification_name)
721: AND pec.legislation_code = 'MX'
722: AND pec.business_group_id IS NULL
723: AND pec.parent_classification_id IS NOT NULL

Line 733: l_classification_name pay_element_classifications.classification_name%TYPE;

729: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
730: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
731: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
732: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
733: l_classification_name pay_element_classifications.classification_name%TYPE;
734: l_classification_id NUMBER;
735: l_counter NUMBER;
736: l_proc_name VARCHAR2(100);
737: l_index NUMBER;