APPS.BEN_DETERMINE_DATE dependencies on PER_ALL_ASSIGNMENTS_F

Line 643: from per_all_assignments_f asg

639: l_pil_row ben_per_in_ler%rowtype;
640: --
641: cursor c_asg is
642: select asg.assignment_id,asg.organization_id
643: from per_all_assignments_f asg
644: where asg.person_id = l_person_id
645: and asg.assignment_type <> 'C'
646: and asg.primary_flag = 'Y'
647: and nvl(p_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date)) between asg.effective_start_date

Line 699: per_all_assignments_f asg

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
703: and asg.person_id = l_person_id

Line 716: from hr_locations_all loc,per_all_assignments_f asg

712: order by decode(asg.assignment_type,'E',1,2) asc;
713: --
714: Cursor c_state is
715: select region_2
716: from hr_locations_all loc,per_all_assignments_f asg
717: where loc.location_id = asg.location_id
718: and asg.person_id = p_person_id
719: and asg.assignment_type <> 'C'
720: and p_effective_date between

Line 732: per_all_assignments_f asg

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
736: and asg.person_id = l_person_id

Line 752: per_all_assignments_f asg

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
756: and asg.person_id = l_person_id

Line 769: per_all_assignments_f asg

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
773: and asg.person_id = l_person_id

Line 786: per_all_assignments_f asg

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
790: and asg.person_id = l_person_id

Line 807: per_all_assignments_f asg

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
811: and asg.person_id = l_person_id

Line 1073: per_all_assignments_f asg

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
1077: and asg.person_id = l_person_id