APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 438: pay_element_types_f pet,

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
442: AND pet.element_type_id = psr.element_type_id

Line 603: pay_element_types_f pet,

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
607: AND pet.element_type_id = psr.element_type_id

Line 768: pay_element_types_f pet,

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
772: AND pet.element_type_id = psr.element_type_id

Line 4060: ,pay_element_types_f pet

4056: CURSOR get_isr_entry
4057: IS
4058: SELECT 'Y'
4059: FROM pay_element_entries_f pee
4060: ,pay_element_types_f pet
4061: ,pay_element_entry_values_f pev
4062: ,pay_input_values_f piv
4063: WHERE assignment_id=P_CTX_ASSIGNMENT_ID
4064: AND pee.element_type_id=pet.element_type_id