DBA Data[Home] [Help]

APPS.PAY_CONTACT_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO_S

Line 59: select per_assignment_extra_info_s.nextval

55: ,AEI_INFORMATION_CATEGORY
56: ,AEI_INFORMATION1
57: ,AEI_INFORMATION2
58: ,AEI_INFORMATION3)
59: select per_assignment_extra_info_s.nextval
60: , p_assignment_id
61: , 'PAYROLL_CONTACT'
62: , 'PAYROLL_CONTACT'
63: , p_contact_name

Line 75: select per_assignment_extra_info_s.currval

71: and paf.business_group_id = p_business_group_id
72: and paf.assignment_id = p_assignment_id
73: and aei.aei_information_category = 'PAYROLL_CONTACT');
74: --
75: select per_assignment_extra_info_s.currval
76: into l_extra_info_id
77: from dual;
78: --
79: ELSE