DBA Data[Home] [Help]

APPS.PQP_USTIAA_PKG dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 357: pay_element_type_extra_info ei

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
361: AND ei.information_type = 'US_TIAA_CREF_CONT_TYPES'

Line 605: pay_element_type_extra_info ei

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
609: AND ei.information_type = 'US_TIAA_CREF_CONT_TYPES'

Line 615: pay_element_type_extra_info ei1

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
619: AND ei1.information_type = 'US_TIAA_CREF_CONT_TYPES'

Line 833: pay_element_type_extra_info ei

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
837: and ei.information_type = 'US_TIAA_CREF_CONT_TYPES'

Line 852: pay_element_type_extra_info ei

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
856: AND ei.information_type = 'US_TIAA_CREF_CONT_TYPES'