APPS.HR_JP_ID_PKG dependencies on PAY_GRADE_RULES_F

Line 1767: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_GRADE_RULES_F%ROWTYPE

1763: FUNCTION grade_rule_rec(
1764: p_rate_id IN NUMBER,
1765: p_grade_id IN NUMBER,
1766: -- p_rate_type IN VARCHAR2,
1767: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_GRADE_RULES_F%ROWTYPE
1768: --------------------------------------------------------------------------------
1769: IS
1770: l_unique_column_tbl UniColTbl;
1771: l_csr RefCsr;

Line 1772: l_rec PAY_GRADE_RULES_F%ROWTYPE;

1768: --------------------------------------------------------------------------------
1769: IS
1770: l_unique_column_tbl UniColTbl;
1771: l_csr RefCsr;
1772: l_rec PAY_GRADE_RULES_F%ROWTYPE;
1773: BEGIN
1774: unique_tbl_constructor('RATE_ID','N',to_char(p_rate_id),l_unique_column_tbl);
1775: unique_tbl_constructor('GRADE_OR_SPINAL_POINT_ID','N',to_char(p_grade_id),l_unique_column_tbl);
1776: -- Current version supports only 'GRADE'. 'SPINAL POINT' is not supported.

Line 1779: l_csr := csr('PAY_GRADE_RULES_F',l_unique_column_tbl);

1775: unique_tbl_constructor('GRADE_OR_SPINAL_POINT_ID','N',to_char(p_grade_id),l_unique_column_tbl);
1776: -- Current version supports only 'GRADE'. 'SPINAL POINT' is not supported.
1777: unique_tbl_constructor('RATE_TYPE','T','G',l_unique_column_tbl);
1778:
1779: l_csr := csr('PAY_GRADE_RULES_F',l_unique_column_tbl);
1780: fetch l_csr into l_rec;
1781: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
1782: l_rec := NULL;
1783: end if;