APPS.PSP_EFFORTS_PKG dependencies on PSP_EFFORT_REPORT_ELEMENTS

Line 249: FROM psp_effort_report_elements

245: BEGIN
246: BEGIN
247: SELECT 'x'
248: INTO t_dummy
249: FROM psp_effort_report_elements
250: WHERE element_type_id = element_type_id1
251: -- Introduced BG/SOB check for bug fix 3098050
252: AND business_group_id = p_business_group_id
253: AND set_of_books_id = p_set_of_books_id

Line 1165: --dbms_output.put_line('The Element Type(s) Are Not Set Up in PSP_EFFORT_REPORT_ELEMENTS' );

1161: ELSIF g_element_flag = 'N' AND g_dist_flag = 'Y' THEN
1162: FND_MESSAGE.set_name('PSP','PSP_NO_MATCHING_ELEMENTS');
1163: errbuf1 := FND_MESSAGE.get;
1164: errbuf := SUBSTR(errbuf1,1,230); --- More than 230 , it gives value error
1165: --dbms_output.put_line('The Element Type(s) Are Not Set Up in PSP_EFFORT_REPORT_ELEMENTS' );
1166: retcode := 2;
1167: ---RETURN;
1168: ELSIF g_dist_flag = 'N' THEN
1169: FND_MESSAGE.set_name('PSP','PSP_NO_DISTRIBUTIONS');