DBA Data[Home] [Help]

APPS.PQP_AAT_BUS dependencies on PAY_RATES

Line 1369: -- tp_safeguarded_rate_id against table pay_rates

1365: -- {Start Of Comments}
1366: --
1367: -- Description:
1368: -- This procedure is used to validate tp_safeguarded_rate_type and
1369: -- tp_safeguarded_rate_id against table pay_rates
1370: --
1371: -- Pre Conditions:
1372: --
1373: -- In Arguments:

Line 1395: From pay_rates pr

1391: ) IS
1392: --
1393: Cursor ChkRate is
1394: Select 'Y'
1395: From pay_rates pr
1396: Where pr.rate_type = p_tp_safeguarded_rate_type
1397: and pr.rate_id = p_tp_safeguarded_rate_id;
1398: --
1399: l_proc varchar2(72) := g_package || 'chk_tp_safeguarded_rate';

Line 1619: From pay_rates pr

1615: ) IS
1616: --
1617: Cursor ChkGradeSpine is
1618: Select 'Y'
1619: From pay_rates pr
1620: ,per_grade_spines_f pgs
1621: ,per_spinal_point_steps_f psps
1622: Where pr.parent_spine_id = pgs.parent_spine_id
1623: and psps.grade_spine_id = pgs.grade_spine_id