APPS.PSP_AUTOPOP dependencies on PSP_AUTO_SEGMENTS

Line 587: Segment Number will now be picked from PSP_AUTO_SEGMENTS

583: ret_gl_code_combination_id OUT NOCOPY NUMBER,
584: retcode OUT NOCOPY VARCHAR2) IS
585: /**************************************************************************************************
586:
587: Segment Number will now be picked from PSP_AUTO_SEGMENTS
588:
589: l_segment_num NUMBER(3):= TO_NUMBER(FND_PROFILE.VALUE('PSP_AUTOP_SEG_NUM'));
590:
591: ***************************************************************************************************/

Line 768: FROM psp_auto_segments

764: p_gl_code_combination_id = ' || p_gl_code_combination_id ||' p_payroll_date = ' || p_payroll_date );
765: IF p_acct_type = 'N' THEN
766: SELECT segment_number
767: INTO l_segment_num
768: FROM psp_auto_segments
769: WHERE business_group_id = p_business_group_id
770: AND set_of_books_id = p_set_of_books_id;
771:
772: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: Getting the value of l_segment_num'|| l_segment_num);