APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 369: pay_element_types_f pet,

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

Line 534: pay_element_types_f pet,

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

Line 699: pay_element_types_f pet,

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

Line 2762: ,pay_element_types_f pet

2758: CURSOR get_isr_entry
2759: IS
2760: SELECT 'Y'
2761: FROM pay_element_entries_f pee
2762: ,pay_element_types_f pet
2763: ,pay_element_entry_values_f pev
2764: ,pay_input_values_f piv
2765: WHERE assignment_id=P_CTX_ASSIGNMENT_ID
2766: AND pee.element_type_id=pet.element_type_id