APPS.GHR_PA_REQUESTS_PKG2 dependencies on PER_ASSIGNMENTS_F

Line 541: from per_assignments_f paf,

537: duty_sta_exp EXCEPTION;
538:
539: cursor cur_loc is
540: select paf.location_id location_id
541: from per_assignments_f paf,
542: per_assignment_status_types ast
543: where paf.person_id = p_person_id
544: and p_effective_date
545: between paf.effective_start_date and paf.effective_end_date

Line 550: select 1 from per_assignments_f

546: and ast.assignment_status_type_id = paf.assignment_status_type_id
547: and ast.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN','TERM_ASSIGN');
548:
549: cursor cur_asg is
550: select 1 from per_assignments_f
551: Where person_id = p_person_id
552: and effective_start_date = to_date('19'||'99/01/01','YYYY/MM/DD');
553:
554:

Line 704: FUNCTION get_cop ( p_assignment_id IN per_assignments_f.assignment_id%type

700: RETURN (l_capped_other_pay);
701:
702: END get_corr_cop;
703:
704: FUNCTION get_cop ( p_assignment_id IN per_assignments_f.assignment_id%type
705: ,p_effective_date IN date)
706:
707: RETURN NUMBER IS
708: l_capped_other_pay NUMBER;