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

Line 717: from hr_locations_all loc,per_all_assignments_f asg

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

Line 733: per_all_assignments_f asg

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

Line 753: per_all_assignments_f asg

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

Line 770: per_all_assignments_f asg

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

Line 787: per_all_assignments_f asg

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

Line 809: per_all_assignments_f asg

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

Line 1075: per_all_assignments_f asg

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