APPS.PAY_DK_PR_ELE dependencies on PAY_BALANCE_PKG

Line 200: SUM (pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id

196: ,p_from_date DATE
197: ,p_to_date DATE)
198: IS
199: SELECT
200: SUM (pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id
201: (pivf.input_value_id,'_ASG_RUN')
202: ,paa1.assignment_action_id)) ele_ytd
203: FROM
204: per_all_assignments_f paaf

Line 275: ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id

271: ,NVL(petf.reporting_name,petf.element_name) ele_name
272: ,pay_dk_pr_ele.costed_code(prr.run_result_id,pivf.input_value_id) costed_code
273: ,pivf.input_value_id input_value_id
274: ,to_char(ppa1.date_earned,'DD-MON-RRRR') date_earned
275: ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id
276: (pivf.input_value_id,'_ASG_RUN')
277: ,paa1.assignment_action_id) pay_value
278: /* ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id
279: (pivf.input_value_id,'_ASG_YTD'),

Line 278: /* ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id

274: ,to_char(ppa1.date_earned,'DD-MON-RRRR') date_earned
275: ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id
276: (pivf.input_value_id,'_ASG_RUN')
277: ,paa1.assignment_action_id) pay_value
278: /* ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id
279: (pivf.input_value_id,'_ASG_YTD'),
280: paa1.assignment_action_id) balance_amount*/
281: FROM
282: per_all_assignments_f paaf

Line 365: ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id

361: ,NVL(petf.reporting_name,petf.element_name) ele_name
362: ,pay_dk_pr_ele.costed_code(prr.run_result_id,pivf.input_value_id) costed_code
363: ,pivf.input_value_id input_value_id
364: ,to_char(ppa1.date_earned,'DD-MON-RRRR') date_earned
365: ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id
366: (pivf.input_value_id,'_ASG_RUN')
367: ,paa1.assignment_action_id) pay_value
368: /* ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id
369: (pivf.input_value_id,'_ASG_YTD'),

Line 368: /* ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id

364: ,to_char(ppa1.date_earned,'DD-MON-RRRR') date_earned
365: ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id
366: (pivf.input_value_id,'_ASG_RUN')
367: ,paa1.assignment_action_id) pay_value
368: /* ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id
369: (pivf.input_value_id,'_ASG_YTD'),
370: paa1.assignment_action_id) balance_amount*/
371: FROM
372: