APPS.PAY_ADHOC_UTILS_PKG dependencies on PER_PAY_PROPOSALS

Line 599: FROM per_pay_proposals pro

595: c_start_date DATE,
596: c_end_date DATE,
597: c_date DATE) IS
598: SELECT pro.proposed_salary_n
599: FROM per_pay_proposals pro
600: WHERE pro.assignment_id = c_assignment_id
601: AND pro.change_date =(SELECT max(pro2.change_date)
602: FROM per_pay_proposals pro2
603: WHERE pro2.assignment_id = c_assignment_id

Line 602: FROM per_pay_proposals pro2

598: SELECT pro.proposed_salary_n
599: FROM per_pay_proposals pro
600: WHERE pro.assignment_id = c_assignment_id
601: AND pro.change_date =(SELECT max(pro2.change_date)
602: FROM per_pay_proposals pro2
603: WHERE pro2.assignment_id = c_assignment_id
604: AND pro2.change_date < c_date)
605: AND pro.change_date < c_date ;
606: --

Line 645: FROM per_pay_proposals pro

641: --
642: CURSOR previous_pay_date(c_assignment_id NUMBER,
643: c_period_end_date DATE) IS
644: SELECT max(pro.change_date)
645: FROM per_pay_proposals pro
646: WHERE pro.assignment_id = c_assignment_id
647: AND pro.change_date < c_period_end_date;
648: --
649: ld_date DATE;

Line 675: FROM per_pay_proposals

671: multiple_flag VARCHAR2(1);
672: --
673: BEGIN
674: SELECT count(*) INTO v_count
675: FROM per_pay_proposals
676: WHERE assignment_id = p_assignment_id
677: AND change_date between p_start_date and p_end_date;
678:
679: IF v_count < 0 or v_count = 1 THEN