APPS.PQP_USTIAA_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 356: pay_element_types_f e,

352: AND endperson
353: AND EXISTS (
354: select NULL
355: FROM pay_run_results rr,
356: pay_element_types_f e,
357: pay_element_type_extra_info ei
358: WHERE rr.assignment_action_id = act_run.assignment_action_id
359: AND rr.element_type_id = e.element_type_id
360: AND e.element_type_id = ei.element_type_id

Line 604: pay_element_types_f e,

600:
601: Cursor csr_chk_dup_bal_types is
602: SELECT count(*)
603: FROM pay_run_results rr,
604: pay_element_types_f e,
605: pay_element_type_extra_info ei
606: WHERE rr.assignment_action_id = p_asgact_id
607: AND rr.element_type_id = e.element_type_id
608: AND e.element_type_id = ei.element_type_id

Line 614: pay_element_types_f e1,

610: AND p_date BETWEEN e.effective_start_date AND e.effective_end_date
611: AND rr.entry_type not in ('A','R')
612: and rr.rowid > (SELECT min(rr1.rowid)
613: FROM pay_run_results rr1,
614: pay_element_types_f e1,
615: pay_element_type_extra_info ei1
616: WHERE rr1.assignment_action_id = rr.assignment_action_id
617: AND rr1.element_type_id = e1.element_type_id
618: AND e1.element_type_id = ei1.element_type_id

Line 855: pay_element_types_f e,

851: paa.tax_unit_id)
852: AND EXISTS (
853: select NULL
854: from pay_element_entries_f ee,
855: pay_element_types_f e,
856: pay_element_type_extra_info ei
857: where ee.assignment_id = paa.assignment_id
858: and ee.element_type_id = e.element_type_id
859: and ei.element_type_id = e.element_type_id

Line 876: pay_element_types_f e,

872: ei.eei_information3 plan_no,
873: e.element_information10 bal_type_id,
874: e.element_name
875: FROM pay_run_results rr,
876: pay_element_types_f e,
877: pay_element_type_extra_info ei
878: WHERE rr.assignment_action_id = p_asgact_id
879: AND rr.element_type_id = e.element_type_id
880: AND e.element_type_id = ei.element_type_id