[Home] [Help]
1146: or (ffc.context_name = 'SOURCE_TEXT' AND
1147: exists ( select 1
1148: from pay_run_results rr,
1149: pay_run_result_values rrv,
1150: pay_input_values_f piv,
1151: pay_element_types_f petf
1152: where rr.assignment_action_id = pca.assignment_action_id
1153: and rr.element_type_id = petf.element_type_id
1154: and rr.run_result_id = rrv.run_result_id
3532: -- depending on the balance, and used as the reported dimension name.
3533: -- Where there is no reference, the displayed dimension defaults to
3534: -- _ELEMENT_PTD or _ELEMENT_ITD.
3535: -- Bug 1146055, use Run Results instead of element entries,
3536: -- note still uses view pay_input_values.
3537: --
3538: -------------------------------------------------------------------------------
3539: --
3540: FUNCTION get_element_reference(p_run_result_id IN NUMBER,
3549: cursor get_run_result_value (c_run_result_id NUMBER) is
3550: SELECT prrv.result_value
3551: FROM pay_run_result_values prrv,
3552: pay_run_results prr,
3553: pay_input_values iv
3554: WHERE prr.run_result_id = c_run_result_id
3555: AND prr.run_result_id = prrv.run_result_id
3556: AND iv.name = 'Reference'
3557: AND iv.input_value_id = prrv.input_value_id;