APPS.BEN_DETERMINE_DATE dependencies on PER_TIME_PERIODS

Line 698: from per_time_periods tpe,

694: --
695: cursor c_pay_period is
696: select tpe.start_date,
697: tpe.end_date
698: from per_time_periods tpe,
699: per_all_assignments_f asg
700: where tpe.payroll_id = asg.payroll_id
701: and asg.assignment_type <> 'C'
702: and asg.business_group_id = l_business_group_id

Line 731: from per_time_periods tpe,

727: --
728: cursor c_pay_period_for_date(p_date_dt date) is
729: select tpe.start_date,
730: tpe.end_date
731: from per_time_periods tpe,
732: per_all_assignments_f asg
733: where tpe.payroll_id = asg.payroll_id
734: and asg.assignment_type <> 'C'
735: and asg.business_group_id = l_business_group_id

Line 751: from per_time_periods tpe,

747: --
748: --pay period on check date
749: cursor c_pay_period_for_check (p_date_dt date, p_assignment_type varchar2) is
750: select min(tpe.start_date )
751: from per_time_periods tpe,
752: per_all_assignments_f asg
753: where tpe.payroll_id = asg.payroll_id
754: and asg.assignment_type = p_assignment_type
755: and asg.business_group_id = l_business_group_id

Line 768: from per_time_periods tpe,

764: --
765: cursor c_pay_period_for_check_end
766: (p_date_dt date, p_assignment_type varchar2) is
767: select max(tpe.end_date )
768: from per_time_periods tpe,
769: per_all_assignments_f asg
770: where tpe.payroll_id = asg.payroll_id
771: and asg.assignment_type = p_assignment_type
772: and asg.business_group_id = l_business_group_id

Line 785: from per_time_periods tpe,

781: --
782: cursor c_next_pay_period(p_date_dt date) is
783: select tpe.start_date,
784: tpe.end_date
785: from per_time_periods tpe,
786: per_all_assignments_f asg
787: where tpe.payroll_id = asg.payroll_id
788: and asg.assignment_type <> 'C'
789: and asg.business_group_id = l_business_group_id

Line 806: from per_time_periods tpe,

802: --6025969 fix
803: cursor c_pre_pay_period(p_date_dt date) is
804: select tpe.start_date,
805: tpe.end_date
806: from per_time_periods tpe,
807: per_all_assignments_f asg
808: where tpe.payroll_id = asg.payroll_id
809: and asg.assignment_type <> 'C'
810: and asg.business_group_id = l_business_group_id

Line 1072: from per_time_periods tpe,

1068: where pil.per_in_ler_id = p_per_in_ler_id;
1069: --
1070: cursor c_pay_id is
1071: select asg.payroll_id
1072: from per_time_periods tpe,
1073: per_all_assignments_f asg
1074: where tpe.payroll_id = asg.payroll_id
1075: and asg.assignment_type <> 'C'
1076: and asg.business_group_id = l_business_group_id