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 832: pay_element_types_f e,

828: paa.tax_unit_id)
829: AND EXISTS (
830: select NULL
831: from pay_element_entries_f ee,
832: pay_element_types_f e,
833: pay_element_type_extra_info ei
834: where ee.assignment_id = paa.assignment_id
835: and ee.element_type_id = e.element_type_id
836: and ei.element_type_id = e.element_type_id

Line 851: pay_element_types_f e,

847: ei.eei_information3 plan_no,
848: e.element_information10 bal_type_id,
849: e.element_name
850: FROM pay_run_results rr,
851: pay_element_types_f e,
852: pay_element_type_extra_info ei
853: WHERE rr.assignment_action_id = p_asgact_id
854: AND rr.element_type_id = e.element_type_id
855: AND e.element_type_id = ei.element_type_id