APPS.HR_JP_ID_PKG dependencies on PAY_BALANCE_FEEDS_F

Line 1215: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_BALANCE_FEEDS_F%ROWTYPE

1211: p_input_value_id IN NUMBER,
1212: p_business_group_id IN NUMBER DEFAULT NULL,
1213: p_legislation_code IN VARCHAR2 DEFAULT NULL,
1214: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1215: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_BALANCE_FEEDS_F%ROWTYPE
1216: --------------------------------------------------------------------------------
1217: IS
1218: l_unique_column_tbl UniColTbl;
1219: l_csr RefCsr;

Line 1220: l_rec PAY_BALANCE_FEEDS_F%ROWTYPE;

1216: --------------------------------------------------------------------------------
1217: IS
1218: l_unique_column_tbl UniColTbl;
1219: l_csr RefCsr;
1220: l_rec PAY_BALANCE_FEEDS_F%ROWTYPE;
1221: BEGIN
1222: unique_tbl_constructor('BALANCE_TYPE_ID','N',to_char(p_balance_type_id),l_unique_column_tbl);
1223: unique_tbl_constructor('INPUT_VALUE_ID','N',to_char(p_input_value_id),l_unique_column_tbl);
1224: bus_leg_constructor(p_business_group_id,p_legislation_code,l_unique_column_tbl);

Line 1226: l_csr := csr('PAY_BALANCE_FEEDS_F',l_unique_column_tbl,'DATETRACKED',p_effective_date);

1222: unique_tbl_constructor('BALANCE_TYPE_ID','N',to_char(p_balance_type_id),l_unique_column_tbl);
1223: unique_tbl_constructor('INPUT_VALUE_ID','N',to_char(p_input_value_id),l_unique_column_tbl);
1224: bus_leg_constructor(p_business_group_id,p_legislation_code,l_unique_column_tbl);
1225:
1226: l_csr := csr('PAY_BALANCE_FEEDS_F',l_unique_column_tbl,'DATETRACKED',p_effective_date);
1227: fetch l_csr into l_rec;
1228: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
1229: l_rec := NULL;
1230: end if;

Line 1255: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_BALANCE_FEEDS_F%ROWTYPE

1251: p_name IN VARCHAR2,
1252: p_business_group_id IN NUMBER DEFAULT NULL,
1253: p_legislation_code IN VARCHAR2 DEFAULT NULL,
1254: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1255: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_BALANCE_FEEDS_F%ROWTYPE
1256: --------------------------------------------------------------------------------
1257: IS
1258: l_balance_type_id NUMBER;
1259: l_input_value_id NUMBER;