APPS.BEN_EXT_THREAD dependencies on PER_ALL_ASSIGNMENTS_F

Line 3576: ' FROM per_all_assignments_f ben_asg ' ||

3572: IF l_pen_ext_dfn_id = p_ext_dfn_id
3573: THEN
3574: l_dynamic_sql :=
3575: ' SELECT distinct(per.person_id) person_id ' ||
3576: ' FROM per_all_assignments_f ben_asg ' ||
3577: ' ,per_periods_of_service ppos ' ||
3578: ' ,per_all_people_f per ' ||
3579: ' WHERE per.person_id = ben_asg.person_id (+) ' ||
3580: ' AND ben_asg.period_of_service_id = ppos.period_of_service_id ' ||

Line 3606: 'per_all_assignments_f ben_asg ' ||

3602: l_dynamic_sql :=
3603: 'select distinct(per.person_id) person_id ' ||
3604: 'from ' ||
3605: 'per_all_people_f per, ' ||
3606: 'per_all_assignments_f ben_asg ' ||
3607: 'where ' ||
3608: 'per.person_id = ben_asg.person_id (+)' ||
3609: ' and to_date(''' || to_char(p_effective_date,'DD-MM-RRRR') || ''',''DD-MM-RRRR'') between per.effective_start_date and per.effective_end_date ' ||
3610: ' and to_date(''' || to_char(p_effective_date,'DD-MM-RRRR') || ''',''DD-MM-YYYY'') between ben_asg.effective_start_date (+) ' ||

Line 3618: 'per_all_assignments_f ben_asg ' ||

3614: l_dynamic_sql :=
3615: 'select distinct(per.person_id) person_id ' ||
3616: 'from ' ||
3617: 'per_all_people_f per, ' ||
3618: 'per_all_assignments_f ben_asg ' ||
3619: 'where ' ||
3620: 'per.person_id = ben_asg.person_id (+)' ||
3621: ' and to_date(''' || to_char(p_effective_date,'DD-MM-RRRR') || ''',''DD-MM-RRRR'') between per.effective_start_date and per.effective_end_date ' ||
3622: ' and to_date(''' || to_char(p_effective_date,'DD-MM-RRRR') || ''',''DD-MM-YYYY'') between ben_asg.effective_start_date (+) ' ||

Line 3685: 'per_all_assignments_f ben_asg ' ||

3681: 'select distinct(xcl.person_id) person_id ' ||
3682: 'from ' ||
3683: 'ben_ext_chg_evt_log xcl, ' ||
3684: 'per_all_people_f per, ' ||
3685: 'per_all_assignments_f ben_asg ' ||
3686: 'where ' ||
3687: 'xcl.person_id = per.person_id ' ||
3688: ' and xcl.person_id = ben_asg.person_id (+) ' ||
3689: ' and xcl.chg_eff_dt between per.effective_start_date and per.effective_end_date ' ||

Line 3769: 'per_all_assignments_f ben_asg ' ||

3765: l_dynamic_pay_sql :=
3766: 'select distinct(per.person_id) person_id ' ||
3767: 'from ' ||
3768: 'per_all_people_f per , ' ||
3769: 'per_all_assignments_f ben_asg ' ||
3770: 'where ' ||
3771: ' ben_asg.person_id = per.person_id ' ||
3772: ' and to_date(''' || to_char(p_effective_date,'DD-MM-RRRR') ||
3773: ''',''DD-MM-RRRR'') between per.effective_start_date and per.effective_end_date '

Line 3781: 'per_all_assignments_f ben_asg ' ||

3777: l_dynamic_pay_sql :=
3778: 'select distinct(ben_asg.person_id) person_id ' ||
3779: 'from ' ||
3780: 'pay_process_events xcl, ' ||
3781: 'per_all_assignments_f ben_asg ' ||
3782: 'where ' ||
3783: ' xcl.assignment_id = ben_asg.assignment_id ' ||
3784: ' and xcl.effective_date between ben_Asg.effective_start_date and ben_Asg.effective_end_date ' ||
3785: ' and xcl.business_group_id = ben_Asg.business_group_id '

Line 3818: 'per_all_assignments_f ben_asg ' ||

3814: 'from ' ||
3815: 'ben_per_cm_f pcm, ' ||
3816: 'ben_per_cm_prvdd_f pcp, ' ||
3817: 'per_all_people_f per, ' ||
3818: 'per_all_assignments_f ben_asg ' ||
3819: 'where ' ||
3820: 'pcm.per_cm_id = pcp.per_cm_id ' ||
3821: ' and pcm.person_id = per.person_id ' ||
3822: ' and per.person_id = ben_asg.person_id (+) ' ||

Line 3850: 'per_all_assignments_f ben_asg ' ||

3846: 'select distinct(cpi.person_id) person_id ' ||
3847: 'from ' ||
3848: 'ben_cwb_person_info cpi, ' ||
3849: 'per_all_people_f per, ' ||
3850: 'per_all_assignments_f ben_asg ' ||
3851: 'where ' ||
3852: 'cpi.person_id = per.person_id ' ||
3853: ' and cpi.person_id = ben_asg.person_id (+) ' ||
3854: -- ' and cpi.business_group_id = ' || p_business_group_id ||

Line 4695: from per_all_assignments_f asg

4691: l_proc varchar2(80) := g_package||'.check_asg_security';
4692:
4693: cursor c_asg is
4694: select asg.ASSIGNMENT_TYPE ,asg.assignment_id,asg.business_group_id
4695: from per_all_assignments_f asg
4696: where asg.person_id = p_person_id
4697: and asg.primary_flag = 'Y'
4698: and p_effective_date between asg.effective_start_date
4699: and asg.effective_end_date

Line 4705: from per_all_assignments_f asg

4701:
4702:
4703: cursor c_sec_asg (p_assignment_id number) is
4704: select 'x'
4705: from per_all_assignments_f asg
4706: where asg.assignment_id = p_assignment_id
4707: and p_effective_date between asg.effective_start_date
4708: and asg.effective_end_date ;
4709:

Line 4712: l_ASSIGNMENT_TYPE per_all_assignments_f.ASSIGNMENT_TYPE%type ;

4708: and asg.effective_end_date ;
4709:
4710:
4711:
4712: l_ASSIGNMENT_TYPE per_all_assignments_f.ASSIGNMENT_TYPE%type ;
4713: l_assignment_id per_all_assignments_f.assignment_id%type ;
4714: l_business_group_id per_all_assignments_f.business_group_id%type ;
4715: l_return boolean ;
4716: l_temp varchar2(1) ;

Line 4713: l_assignment_id per_all_assignments_f.assignment_id%type ;

4709:
4710:
4711:
4712: l_ASSIGNMENT_TYPE per_all_assignments_f.ASSIGNMENT_TYPE%type ;
4713: l_assignment_id per_all_assignments_f.assignment_id%type ;
4714: l_business_group_id per_all_assignments_f.business_group_id%type ;
4715: l_return boolean ;
4716: l_temp varchar2(1) ;
4717: begin

Line 4714: l_business_group_id per_all_assignments_f.business_group_id%type ;

4710:
4711:
4712: l_ASSIGNMENT_TYPE per_all_assignments_f.ASSIGNMENT_TYPE%type ;
4713: l_assignment_id per_all_assignments_f.assignment_id%type ;
4714: l_business_group_id per_all_assignments_f.business_group_id%type ;
4715: l_return boolean ;
4716: l_temp varchar2(1) ;
4717: begin
4718:

Line 4767: HR_SECURITY.SHOW_RECORD('PER_ALL_ASSIGNMENTS_F', L_ASSIGNMENT_ID, P_PERSON_ID, L_ASSIGNMENT_TYPE) <> 'TRUE' then

4763: -- if the assignment type is E or C validate against the sec view
4764: if l_ASSIGNMENT_TYPE in ('E','C') then
4765:
4766: if HR_SECURITY.VIEW_ALL <> 'Y' and
4767: HR_SECURITY.SHOW_RECORD('PER_ALL_ASSIGNMENTS_F', L_ASSIGNMENT_ID, P_PERSON_ID, L_ASSIGNMENT_TYPE) <> 'TRUE' then
4768: -- hr_utility.set_location ('Exiting false'||l_proc,9);
4769: return false ;
4770: end if ;
4771: end if ;