APPS.PA_UTILS2 dependencies on PA_PERIODS_ALL

Line 570: FROM pa_periods_all pap1

566: ,pap1.period_name
567: INTO l_earliest_start_date
568: ,l_earliest_end_date
569: ,l_earliest_period_name
570: FROM pa_periods_all pap1
571: WHERE pap1.status in ('O','F')
572: AND pap1.org_id = p_org_id /* Bug#9048873 */
573: AND pap1.start_date = ( SELECT MIN (pap.start_date)
574: FROM pa_periods_all pap

Line 574: FROM pa_periods_all pap

570: FROM pa_periods_all pap1
571: WHERE pap1.status in ('O','F')
572: AND pap1.org_id = p_org_id /* Bug#9048873 */
573: AND pap1.start_date = ( SELECT MIN (pap.start_date)
574: FROM pa_periods_all pap
575: WHERE pap.status in ('O','F')
576: AND pap.org_id = p_org_id /* Bug#9048873 */
577: );
578: l_stage := 25;

Line 614: FROM pa_periods_all pap

610: INTO l_pa_date
611: ,l_start_date
612: ,l_end_date
613: ,l_period_name
614: FROM pa_periods_all pap
615: WHERE pap.status in ('O','F')
616: AND trunc(p_ei_date) between pap.start_date and pap.end_date
617: AND pap.org_id = p_org_id ; --removed nvl for the bug#6343739
618: EXCEPTION

Line 633: FROM pa_periods_all pap1

629: INTO l_pa_date
630: ,l_start_date
631: ,l_end_date
632: ,l_period_name
633: FROM pa_periods_all pap1
634: WHERE pap1.status in ('O','F')
635: AND nvl( pap1.org_id, -99 ) = nvl( p_org_id, -99 )
636: AND pap1.start_date = ( SELECT MIN (pap.start_date)
637: FROM pa_periods_all pap

Line 637: FROM pa_periods_all pap

633: FROM pa_periods_all pap1
634: WHERE pap1.status in ('O','F')
635: AND nvl( pap1.org_id, -99 ) = nvl( p_org_id, -99 )
636: AND pap1.start_date = ( SELECT MIN (pap.start_date)
637: FROM pa_periods_all pap
638: WHERE pap.status in ('O','F')
639: AND pap.org_id = p_org_id --removed nvl for the bug#6343739
640: AND trunc(p_ei_date) <= pap.start_date
641: );

Line 705: FROM pa_periods_all pap

701: INTO l_pa_date
702: ,l_start_date
703: ,l_end_date
704: ,l_period_name
705: FROM pa_periods_all pap
706: WHERE pap.status in ('O','F')
707: AND trunc(p_ei_date) between pap.start_date and pap.end_date
708: AND pap.org_id = p_org_id; /*removed nvl for bug 9284457 */
709: l_stage := 28;

Line 725: FROM pa_periods_all pap1

721: INTO l_pa_date
722: ,l_start_date
723: ,l_end_date
724: ,l_period_name
725: FROM pa_periods_all pap1
726: WHERE pap1.status in ('O','F')
727: AND pap1.org_id = p_org_id /* Bug#9048873 */
728: AND pap1.start_date = ( SELECT MIN (pap.start_date)
729: FROM pa_periods_all pap

Line 729: FROM pa_periods_all pap

725: FROM pa_periods_all pap1
726: WHERE pap1.status in ('O','F')
727: AND pap1.org_id = p_org_id /* Bug#9048873 */
728: AND pap1.start_date = ( SELECT MIN (pap.start_date)
729: FROM pa_periods_all pap
730: WHERE pap.status in ('O','F')
731: AND pap.org_id = p_org_id /* Bug#9048873 */
732: AND trunc(p_ei_date) <= pap.start_date
733: );

Line 3205: FUNCTION get_pa_period_end_date_OU ( p_date IN pa_periods_all.end_date%TYPE)

3201: ---------------------------------------------------------------
3202: /*
3203: * This function returns the end_date of the PA period in which the input date falls.
3204: */
3205: FUNCTION get_pa_period_end_date_OU ( p_date IN pa_periods_all.end_date%TYPE)
3206: RETURN pa_periods_all.end_date%TYPE
3207: IS
3208: l_end_date pa_periods_all.end_date%TYPE ;
3209: BEGIN

Line 3206: RETURN pa_periods_all.end_date%TYPE

3202: /*
3203: * This function returns the end_date of the PA period in which the input date falls.
3204: */
3205: FUNCTION get_pa_period_end_date_OU ( p_date IN pa_periods_all.end_date%TYPE)
3206: RETURN pa_periods_all.end_date%TYPE
3207: IS
3208: l_end_date pa_periods_all.end_date%TYPE ;
3209: BEGIN
3210:

Line 3208: l_end_date pa_periods_all.end_date%TYPE ;

3204: */
3205: FUNCTION get_pa_period_end_date_OU ( p_date IN pa_periods_all.end_date%TYPE)
3206: RETURN pa_periods_all.end_date%TYPE
3207: IS
3208: l_end_date pa_periods_all.end_date%TYPE ;
3209: BEGIN
3210:
3211: SELECT pap.end_date
3212: INTO l_end_date

Line 3333: FROM pa_periods_all papl

3329: -- Either the Cache is empty / date is not in the range
3330: BEGIN
3331: SELECT papl.end_date,papl.start_date,papl.period_name,papl.gl_period_name
3332: INTO l_org_pa_end_date,l_org_pa_start_date,l_org_pa_period_name,l_org_gl_period_name
3333: FROM pa_periods_all papl
3334: WHERE nvl(papl.org_id, -99 ) = nvl( p_org_id, -99 )
3335: AND trunc(p_ei_date) between papl.start_date and papl.end_date;
3336:
3337: IF ( l_org_gl_period_name <> p_gl_period )

Line 3353: FROM pa_periods_all papl

3349:
3350: l_pa_overlaps_gl := 'Y';
3351: SELECT papl.end_date,papl.start_date,papl.period_name
3352: INTO l_org_pa_end_date,l_org_pa_start_date,l_org_pa_period_name
3353: FROM pa_periods_all papl
3354: WHERE nvl(papl.org_id, -99 ) = nvl( p_org_id, -99 )
3355: AND papl.gl_period_name=p_gl_period
3356: AND papl.start_date= ( SELECT MAX(papl1.start_date)
3357: FROM pa_periods_all papl1

Line 3357: FROM pa_periods_all papl1

3353: FROM pa_periods_all papl
3354: WHERE nvl(papl.org_id, -99 ) = nvl( p_org_id, -99 )
3355: AND papl.gl_period_name=p_gl_period
3356: AND papl.start_date= ( SELECT MAX(papl1.start_date)
3357: FROM pa_periods_all papl1
3358: WHERE nvl(papl1.org_id, -99 ) = nvl( p_org_id, -99 )
3359: AND papl1.gl_period_name=p_gl_period
3360: );
3361: END IF;

Line 3463: FROM pa_periods_all papl

3459: ----Rev EI GL date is used to get the pa date. EPP flag is checked in the select itself.
3460: BEGIN
3461: SELECT min(decode(p_epp_flag,'Y',papl.start_date,papl.end_date))
3462: INTO l_rev_pa_date
3463: FROM pa_periods_all papl
3464: WHERE nvl(papl.org_id, -99 ) = nvl(p_org_id, -99 )
3465: AND papl.gl_period_name = p_gl_period ;
3466: END;
3467: IF ( l_debug_mode = 'Y' ) THEN

Line 3478: FROM pa_periods_all papl

3474: -- Get the Period Name
3475: BEGIN
3476: SELECT period_name
3477: INTO l_rev_pa_period_name
3478: FROM pa_periods_all papl
3479: WHERE nvl(papl.org_id, -99 ) = nvl(p_org_id, -99 )
3480: AND trunc(l_rev_pa_date) between papl.start_date and papl.end_date;
3481: EXCEPTION
3482: WHEN NO_DATA_FOUND THEN