APPS.HR_JP_ID_PKG dependencies on PAY_BACKPAY_RULES

Line 2233: P_ERROR_WHEN_NOT_EXIST IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_BACKPAY_RULES%ROWTYPE

2229: FUNCTION backpay_rule_rec(
2230: P_BACKPAY_SET_ID IN NUMBER,
2231: P_DEFINED_BALANCE_ID IN NUMBER,
2232: P_INPUT_VALUE_ID IN NUMBER,
2233: P_ERROR_WHEN_NOT_EXIST IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_BACKPAY_RULES%ROWTYPE
2234: --------------------------------------------------------------------------------
2235: IS
2236: l_unique_column_tbl UniColTbl;
2237: l_csr RefCsr;

Line 2238: l_rec PAY_BACKPAY_RULES%ROWTYPE;

2234: --------------------------------------------------------------------------------
2235: IS
2236: l_unique_column_tbl UniColTbl;
2237: l_csr RefCsr;
2238: l_rec PAY_BACKPAY_RULES%ROWTYPE;
2239: BEGIN
2240: unique_tbl_constructor('BACKPAY_SET_ID','N',to_char(p_backpay_set_id),l_unique_column_tbl);
2241: unique_tbl_constructor('DEFINED_BALANCE_ID','N',to_char(p_defined_balance_id),l_unique_column_tbl);
2242: unique_tbl_constructor('INPUT_VALUE_ID','N',to_char(p_input_value_id),l_unique_column_tbl);

Line 2243: l_csr := csr('PAY_BACKPAY_RULES',l_unique_column_tbl);

2239: BEGIN
2240: unique_tbl_constructor('BACKPAY_SET_ID','N',to_char(p_backpay_set_id),l_unique_column_tbl);
2241: unique_tbl_constructor('DEFINED_BALANCE_ID','N',to_char(p_defined_balance_id),l_unique_column_tbl);
2242: unique_tbl_constructor('INPUT_VALUE_ID','N',to_char(p_input_value_id),l_unique_column_tbl);
2243: l_csr := csr('PAY_BACKPAY_RULES',l_unique_column_tbl);
2244: fetch l_csr into l_rec;
2245: if l_csr%NOTFOUND then
2246: if p_error_when_not_exist = 'TRUE' then
2247: close l_csr;