APPS.BEN_EXT_THREAD dependencies on PER_ALL_ASSIGNMENTS_F

Line 3578: ' FROM per_all_assignments_f ben_asg ' ||

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

Line 3608: 'per_all_assignments_f ben_asg ' ||

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

Line 3620: 'per_all_assignments_f ben_asg ' ||

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

Line 3687: 'per_all_assignments_f ben_asg ' ||

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

Line 3771: 'per_all_assignments_f ben_asg ' ||

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

Line 3783: 'per_all_assignments_f ben_asg ' ||

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

Line 3820: 'per_all_assignments_f ben_asg ' ||

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

Line 3852: 'per_all_assignments_f ben_asg ' ||

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

Line 4697: from per_all_assignments_f asg

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

Line 4707: from per_all_assignments_f asg

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

Line 4714: l_ASSIGNMENT_TYPE per_all_assignments_f.ASSIGNMENT_TYPE%type ;

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

Line 4715: l_assignment_id per_all_assignments_f.assignment_id%type ;

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

Line 4716: l_business_group_id per_all_assignments_f.business_group_id%type ;

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

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

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