APPS.HXT_TD_UTIL dependencies on PER_PAY_PROPOSALS

Line 667: FROM per_pay_proposals pro,

663: IS
664: CURSOR sal_cur
665: IS
666: SELECT pro.proposed_salary, ppb.pay_basis
667: FROM per_pay_proposals pro,
668: per_pay_bases ppb,
669: per_assignments_f asg
670: WHERE pro.assignment_id = p_assignment_id
671: AND ppb.pay_basis_id = asg.pay_basis_id

Line 677: FROM per_pay_proposals pro2

673: AND p_eff_date BETWEEN asg.effective_start_date
674: AND asg.effective_end_date
675: AND pro.approved = 'Y'
676: AND pro.change_date = (SELECT MAX (pro2.change_date)
677: FROM per_pay_proposals pro2
678: WHERE pro2.assignment_id =
679: p_assignment_id
680: AND pro2.approved = 'Y'
681: AND p_eff_date >= pro2.change_date);

Line 690: v_proposed_salary per_pay_proposals_v.proposed_salary%TYPE;

686: FROM per_time_periods ptp, per_time_period_types ptpt
687: WHERE p_ptp_id = ptp.time_period_id
688: AND ptp.period_type = ptpt.period_type;
689:
690: v_proposed_salary per_pay_proposals_v.proposed_salary%TYPE;
691: v_pay_basis per_pay_proposals_v.pay_basis%TYPE;
692: l_hours_per_year NUMBER (22, 5)
693: := TO_NUMBER (fnd_profile.VALUE ('HXT_HOURS_PER_YEAR'));
694: v_annual_pay_periods per_time_period_types.number_per_fiscal_year%TYPE;

Line 691: v_pay_basis per_pay_proposals_v.pay_basis%TYPE;

687: WHERE p_ptp_id = ptp.time_period_id
688: AND ptp.period_type = ptpt.period_type;
689:
690: v_proposed_salary per_pay_proposals_v.proposed_salary%TYPE;
691: v_pay_basis per_pay_proposals_v.pay_basis%TYPE;
692: l_hours_per_year NUMBER (22, 5)
693: := TO_NUMBER (fnd_profile.VALUE ('HXT_HOURS_PER_YEAR'));
694: v_annual_pay_periods per_time_period_types.number_per_fiscal_year%TYPE;
695: BEGIN