DBA Data[Home] [Help]

APPS.PAY_HK_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 149: FUNCTION get_scheme_name(p_run_result_id in pay_run_results.run_result_id%TYPE,

145: /*
146: * Bug 3134158 - Added the following function to return the scheme name
147: *
148: */
149: FUNCTION get_scheme_name(p_run_result_id in pay_run_results.run_result_id%TYPE,
150: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
151: p_business_group_id in hr_organization_units.business_group_id%TYPE)
152: RETURN VARCHAR2
153: IS

Line 176: pay_run_results prr,

172: c_assignment_action_id IN NUMBER)
173: IS
174: SELECT fnd_number.canonical_to_number(prrv.result_value)
175: FROM pay_assignment_actions paa,
176: pay_run_results prr,
177: pay_run_result_values prrv,
178: pay_input_values_f pivf
179: WHERE prr.run_result_id = c_run_result_id
180: AND paa.assignment_action_id = c_assignment_action_id

Line 1189: FUNCTION get_assessed_ri(p_run_result_id in pay_run_results.run_result_id%TYPE)

1185: * Bug 4260143 - Added the following function to return the assessed ri value
1186: */
1187:
1188:
1189: FUNCTION get_assessed_ri(p_run_result_id in pay_run_results.run_result_id%TYPE)
1190: RETURN VARCHAR2 IS
1191:
1192: l_assessed_ri pay_run_result_values.result_value%TYPE;
1193: CURSOR csr_get_accessed_ri