APPS.PER_RO_AEI_INFO dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 87: select 'x' from per_assignment_extra_info

83: p_aei_information_category in varchar2,
84: P_AEI_INFORMATION1 in varchar2
85: ) as
86: cursor csr_contract_details_exist IS
87: select 'x' from per_assignment_extra_info
88: where information_type = p_information_type
89: and aei_information_category = p_aei_information_category
90: and assignment_id=p_assignment_id;
91: l_proc VARCHAR2(60);

Line 133: select assignment_id from per_assignment_extra_info

129: P_AEI_INFORMATION1 in varchar2
130: )
131: as
132: cursor csr_get_assignment_id IS
133: select assignment_id from per_assignment_extra_info
134: where aei_information_category = p_aei_information_category
135: and ASSIGNMENT_EXTRA_INFO_ID = P_ASSIGNMENT_EXTRA_INFO_ID;
136: l_assignment_id per_all_assignments_f.assignment_id%type;
137: l_proc varchar2(60);