APPS.HXT_TD_UTIL dependencies on PER_PAY_PROPOSALS

Line 1453: FROM per_pay_proposals pro,

1449: IS
1450: CURSOR sal_cur
1451: IS
1452: SELECT pro.proposed_salary, ppb.pay_basis
1453: FROM per_pay_proposals pro,
1454: per_pay_bases ppb,
1455: per_assignments_f asg
1456: WHERE pro.assignment_id = p_assignment_id
1457: AND ppb.pay_basis_id = asg.pay_basis_id

Line 1463: FROM per_pay_proposals pro2

1459: AND p_eff_date BETWEEN asg.effective_start_date
1460: AND asg.effective_end_date
1461: AND pro.approved = 'Y'
1462: AND pro.change_date = (SELECT MAX (pro2.change_date)
1463: FROM per_pay_proposals pro2
1464: WHERE pro2.assignment_id =
1465: p_assignment_id
1466: AND pro2.approved = 'Y'
1467: AND p_eff_date >= pro2.change_date);

Line 1476: v_proposed_salary per_pay_proposals_v.proposed_salary%TYPE;

1472: FROM per_time_periods ptp, per_time_period_types ptpt
1473: WHERE p_ptp_id = ptp.time_period_id
1474: AND ptp.period_type = ptpt.period_type;
1475:
1476: v_proposed_salary per_pay_proposals_v.proposed_salary%TYPE;
1477: v_pay_basis per_pay_proposals_v.pay_basis%TYPE;
1478: l_hours_per_year NUMBER (22, 5)
1479: := TO_NUMBER (fnd_profile.VALUE ('HXT_HOURS_PER_YEAR'));
1480: v_annual_pay_periods per_time_period_types.number_per_fiscal_year%TYPE;

Line 1477: v_pay_basis per_pay_proposals_v.pay_basis%TYPE;

1473: WHERE p_ptp_id = ptp.time_period_id
1474: AND ptp.period_type = ptpt.period_type;
1475:
1476: v_proposed_salary per_pay_proposals_v.proposed_salary%TYPE;
1477: v_pay_basis per_pay_proposals_v.pay_basis%TYPE;
1478: l_hours_per_year NUMBER (22, 5)
1479: := TO_NUMBER (fnd_profile.VALUE ('HXT_HOURS_PER_YEAR'));
1480: v_annual_pay_periods per_time_period_types.number_per_fiscal_year%TYPE;
1481: BEGIN