[Home] [Help]
1065:
1066: -- This function is an overloaded function. It checks if an element is defined
1067: -- for actuals. If an elemnt is defined and it has a balance type also defined
1068: -- then it calculates the actual expenditure for an assignment from
1069: -- pay_run_balances. If no balance is defined, then it calls the
1070: -- get_element_actuals procedure to get the actual values. If not it uses
1071: -- the default get_sum_actuals procedure to get the actual value
1072: -- for a given period and for a given element type id . If the
1073: -- element type id is not input , then all element types are taken into
1120: and ppa.effective_date <= c_effective_date);
1121:
1122: cursor csr_act_value(c_assignment_id number,c_defined_balance_id number,c_effective_date date) is
1123: select prb.balance_value
1124: from pay_run_balances prb, pay_assignment_actions paa
1125: where prb.assignment_id = c_assignment_id
1126: and prb.defined_balance_id = c_defined_balance_id
1127: and prb.assignment_action_id = paa.assignment_action_id
1128: and paa.source_action_id is not null
1127: and prb.assignment_action_id = paa.assignment_action_id
1128: and paa.source_action_id is not null
1129: and prb.effective_date =
1130: (select max(effective_date)
1131: from pay_run_balances prb1
1132: where prb1.effective_date <= c_effective_date
1133: and prb1.assignment_id = c_assignment_id and prb1.defined_balance_id = c_defined_balance_id);
1134:
1135: p_ele_id number;