APPS.BEN_DETERMINE_DATE dependencies on PER_TIME_PERIODS

Line 698: from per_time_periods tpe,

694: --
695: cursor c_pay_period(p_assignment_id number default null) is -----------Bug 8394662
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 732: from per_time_periods tpe,

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

Line 752: from per_time_periods tpe,

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

Line 769: from per_time_periods tpe,

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

Line 786: from per_time_periods tpe,

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

Line 808: from per_time_periods tpe,

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

Line 1074: from per_time_periods tpe,

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