DBA Data[Home] [Help]

APPS.PQP_USTIAA_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 505: FROM per_assignment_extra_info paei ,

501:
502: CURSOR csr_asg_plan_no IS
503: SELECT paei.aei_information2,
504: pasg.payroll_id
505: FROM per_assignment_extra_info paei ,
506: per_assignments_f pasg
507: WHERE pasg.assignment_id = p_asg_id
508: AND pasg.assignment_id = paei.assignment_id(+)
509: AND paei.information_type(+) = 'PQP_US_TIAA_CREF_CODES'

Line 568: from per_assignment_extra_info pei

564: p_sub_plan IN out nocopy VARCHAR2) IS
565:
566: CURSOR csr_asg_info IS
567: select pei.aei_information1,pei.aei_information2
568: from per_assignment_extra_info pei
569: where pei.assignment_id = p_asg_id
570: and pei.aei_information_category = 'PAY_US_TIAA_CREF_CONT_TYPE'
571: and pei.aei_information3 = p_ele_entry_id;
572: