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 nvl( pap1.org_id, -99 ) = nvl( p_org_id, -99 )
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 nvl( pap1.org_id, -99 ) = nvl( p_org_id, -99 )
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 nvl( pap.org_id, -99 ) = nvl( p_org_id, -99 )
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 NVL(pap.org_id, -99) = NVL(p_org_id, -99) ;
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 nvl( pap1.org_id, -99 ) = nvl( p_org_id, -99 )
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 nvl( pap1.org_id, -99 ) = nvl( p_org_id, -99 )
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 nvl( pap.org_id, -99 ) = nvl( p_org_id, -99 )
732: AND trunc(p_ei_date) <= pap.start_date
733: );

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

3163: ---------------------------------------------------------------
3164: /*
3165: * This function returns the end_date of the PA period in which the input date falls.
3166: */
3167: FUNCTION get_pa_period_end_date_OU ( p_date IN pa_periods_all.end_date%TYPE)
3168: RETURN pa_periods_all.end_date%TYPE
3169: IS
3170: l_end_date pa_periods_all.end_date%TYPE ;
3171: BEGIN

Line 3168: RETURN pa_periods_all.end_date%TYPE

3164: /*
3165: * This function returns the end_date of the PA period in which the input date falls.
3166: */
3167: FUNCTION get_pa_period_end_date_OU ( p_date IN pa_periods_all.end_date%TYPE)
3168: RETURN pa_periods_all.end_date%TYPE
3169: IS
3170: l_end_date pa_periods_all.end_date%TYPE ;
3171: BEGIN
3172:

Line 3170: l_end_date pa_periods_all.end_date%TYPE ;

3166: */
3167: FUNCTION get_pa_period_end_date_OU ( p_date IN pa_periods_all.end_date%TYPE)
3168: RETURN pa_periods_all.end_date%TYPE
3169: IS
3170: l_end_date pa_periods_all.end_date%TYPE ;
3171: BEGIN
3172:
3173: SELECT pap.end_date
3174: INTO l_end_date

Line 3295: FROM pa_periods_all papl

3291: -- Either the Cache is empty / date is not in the range
3292: BEGIN
3293: SELECT papl.end_date,papl.start_date,papl.period_name,papl.gl_period_name
3294: INTO l_org_pa_end_date,l_org_pa_start_date,l_org_pa_period_name,l_org_gl_period_name
3295: FROM pa_periods_all papl
3296: WHERE nvl(papl.org_id, -99 ) = nvl( p_org_id, -99 )
3297: AND trunc(p_ei_date) between papl.start_date and papl.end_date;
3298:
3299: IF ( l_org_gl_period_name <> p_gl_period )

Line 3315: FROM pa_periods_all papl

3311:
3312: l_pa_overlaps_gl := 'Y';
3313: SELECT papl.end_date,papl.start_date,papl.period_name
3314: INTO l_org_pa_end_date,l_org_pa_start_date,l_org_pa_period_name
3315: FROM pa_periods_all papl
3316: WHERE nvl(papl.org_id, -99 ) = nvl( p_org_id, -99 )
3317: AND papl.gl_period_name=p_gl_period
3318: AND papl.start_date= ( SELECT MAX(papl1.start_date)
3319: FROM pa_periods_all papl1

Line 3319: FROM pa_periods_all papl1

3315: FROM pa_periods_all papl
3316: WHERE nvl(papl.org_id, -99 ) = nvl( p_org_id, -99 )
3317: AND papl.gl_period_name=p_gl_period
3318: AND papl.start_date= ( SELECT MAX(papl1.start_date)
3319: FROM pa_periods_all papl1
3320: WHERE nvl(papl1.org_id, -99 ) = nvl( p_org_id, -99 )
3321: AND papl1.gl_period_name=p_gl_period
3322: );
3323: END IF;

Line 3425: FROM pa_periods_all papl

3421: ----Rev EI GL date is used to get the pa date. EPP flag is checked in the select itself.
3422: BEGIN
3423: SELECT min(decode(p_epp_flag,'Y',papl.start_date,papl.end_date))
3424: INTO l_rev_pa_date
3425: FROM pa_periods_all papl
3426: WHERE nvl(papl.org_id, -99 ) = nvl(p_org_id, -99 )
3427: AND papl.gl_period_name = p_gl_period ;
3428: END;
3429: IF ( l_debug_mode = 'Y' ) THEN

Line 3440: FROM pa_periods_all papl

3436: -- Get the Period Name
3437: BEGIN
3438: SELECT period_name
3439: INTO l_rev_pa_period_name
3440: FROM pa_periods_all papl
3441: WHERE nvl(papl.org_id, -99 ) = nvl(p_org_id, -99 )
3442: AND trunc(l_rev_pa_date) between papl.start_date and papl.end_date;
3443: EXCEPTION
3444: WHEN NO_DATA_FOUND THEN