APPS.HR_JP_ID_PKG dependencies on PAY_FORMULA_RESULT_RULES_F

Line 1472: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_FORMULA_RESULT_RULES_F%ROWTYPE

1468: p_input_value_id IN NUMBER DEFAULT NULL,
1469: p_business_group_id IN NUMBER DEFAULT NULL,
1470: p_legislation_code IN VARCHAR2 DEFAULT NULL,
1471: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1472: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_FORMULA_RESULT_RULES_F%ROWTYPE
1473: --------------------------------------------------------------------------------
1474: IS
1475: l_unique_column_tbl UniColTbl;
1476: l_csr RefCsr;

Line 1477: l_rec PAY_FORMULA_RESULT_RULES_F%ROWTYPE;

1473: --------------------------------------------------------------------------------
1474: IS
1475: l_unique_column_tbl UniColTbl;
1476: l_csr RefCsr;
1477: l_rec PAY_FORMULA_RESULT_RULES_F%ROWTYPE;
1478: BEGIN
1479: unique_tbl_constructor('STATUS_PROCESSING_RULE_ID','N',to_char(p_status_processing_rule_id),l_unique_column_tbl);
1480: unique_tbl_constructor('RESULT_NAME','T',p_result_name,l_unique_column_tbl);
1481: unique_tbl_constructor('RESULT_RULE_TYPE','T',p_result_rule_type,l_unique_column_tbl);

Line 1486: l_csr := csr('PAY_FORMULA_RESULT_RULES_F',l_unique_column_tbl,'DATETRACKED',p_effective_date);

1482: unique_tbl_constructor('ELEMENT_TYPE_ID + 0','N',to_char(p_element_type_id),l_unique_column_tbl);
1483: unique_tbl_constructor('INPUT_VALUE_ID + 0','N',to_char(p_input_value_id),l_unique_column_tbl);
1484: bus_leg_constructor(p_business_group_id,p_legislation_code,l_unique_column_tbl);
1485:
1486: l_csr := csr('PAY_FORMULA_RESULT_RULES_F',l_unique_column_tbl,'DATETRACKED',p_effective_date);
1487: fetch l_csr into l_rec;
1488: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
1489: l_rec := NULL;
1490: end if;