310: hr_utility.set_location('Entering pay_za_soe.Elements1', 10);
311: end if;
312: --
313:
314: l_sql := getElements(p_assignment_action_id, pay_soe_util.getConfig('ELEMENTS1'));
315:
316: --
317: if g_debug then
318: hr_utility.set_location('Leaving pay_za_soe.Elements1', 20);
340: hr_utility.set_location('Entering pay_za_soe.Elements2', 10);
341: end if;
342: --
343:
344: l_sql := getElements(p_assignment_action_id, pay_soe_util.getConfig('ELEMENTS2'));
345:
346: --
347: if g_debug then
348: hr_utility.set_location('Leaving pay_za_soe.Elements2', 20);
370: hr_utility.set_location('Entering pay_za_soe.Elements3', 10);
371: end if;
372: --
373:
374: l_sql := getElements(p_assignment_action_id, pay_soe_util.getConfig('ELEMENTS3'));
375:
376: --
377: if g_debug then
378: hr_utility.set_location('Leaving pay_za_soe.Elements3', 20);
400: hr_utility.set_location('Entering pay_za_soe.Elements4', 10);
401: end if;
402: --
403:
404: l_sql := getElements(p_assignment_action_id, pay_soe_util.getConfig('ELEMENTS4'));
405:
406: --
407: if g_debug then
408: hr_utility.set_location('Leaving pay_za_soe.Elements4', 20);
430: hr_utility.set_location('Entering pay_za_soe.Elements5', 10);
431: end if;
432: --
433:
434: l_sql := getElements(p_assignment_action_id, pay_soe_util.getConfig('ELEMENTS5'));
435:
436: --
437: if g_debug then
438: hr_utility.set_location('Leaving pay_za_soe.Elements5', 20);
460: hr_utility.set_location('Entering pay_za_soe.Elements6', 10);
461: end if;
462: --
463:
464: l_sql := getElements(p_assignment_action_id, pay_soe_util.getConfig('ELEMENTS6'));
465:
466: --
467: if g_debug then
468: hr_utility.set_location('Leaving pay_za_soe.Elements6', 20);
538: end if;
539: --
540:
541: --
542: pay_soe_util.clear;
543: --
544: l_assignment_action_id := p_assignment_action_id;
545:
546: --5507715
573: balance_val := pay_balance_pkg.get_value(dim_id, l_run_assignment_action_id, false);
574:
575: if nvl(balance_val, 0) <> 0 then
576: balance_val := to_char(fnd_number.canonical_to_number(balance_val),fnd_currency.get_format_mask('ZAR',40));
577: pay_soe_util.setValue('01', balance_name, true, false);
578: pay_soe_util.setValue('02', display_name, false, false);
579: pay_soe_util.setValue('16', balance_val, false, true);
580: end if;
581: --
574:
575: if nvl(balance_val, 0) <> 0 then
576: balance_val := to_char(fnd_number.canonical_to_number(balance_val),fnd_currency.get_format_mask('ZAR',40));
577: pay_soe_util.setValue('01', balance_name, true, false);
578: pay_soe_util.setValue('02', display_name, false, false);
579: pay_soe_util.setValue('16', balance_val, false, true);
580: end if;
581: --
582: end loop;
575: if nvl(balance_val, 0) <> 0 then
576: balance_val := to_char(fnd_number.canonical_to_number(balance_val),fnd_currency.get_format_mask('ZAR',40));
577: pay_soe_util.setValue('01', balance_name, true, false);
578: pay_soe_util.setValue('02', display_name, false, false);
579: pay_soe_util.setValue('16', balance_val, false, true);
580: end if;
581: --
582: end loop;
583: --
887: balance_val := pay_balance_pkg.get_value(dim_id, l_run_assignment_action_id, false);
888:
889: if nvl(balance_val, 0) <> 0 then
890: balance_val := to_char(fnd_number.canonical_to_number(balance_val),fnd_currency.get_format_mask('ZAR',40));
891: pay_soe_util.setValue('01', balance_name, true, false);
892: pay_soe_util.setValue('02', balance_name, false, false);
893: pay_soe_util.setValue('16', balance_val, false, true);
894: end if;
895: end if;
888:
889: if nvl(balance_val, 0) <> 0 then
890: balance_val := to_char(fnd_number.canonical_to_number(balance_val),fnd_currency.get_format_mask('ZAR',40));
891: pay_soe_util.setValue('01', balance_name, true, false);
892: pay_soe_util.setValue('02', balance_name, false, false);
893: pay_soe_util.setValue('16', balance_val, false, true);
894: end if;
895: end if;
896: name_count := name_count + 1;
889: if nvl(balance_val, 0) <> 0 then
890: balance_val := to_char(fnd_number.canonical_to_number(balance_val),fnd_currency.get_format_mask('ZAR',40));
891: pay_soe_util.setValue('01', balance_name, true, false);
892: pay_soe_util.setValue('02', balance_name, false, false);
893: pay_soe_util.setValue('16', balance_val, false, true);
894: end if;
895: end if;
896: name_count := name_count + 1;
897:
895: end if;
896: name_count := name_count + 1;
897:
898: end loop;
899: l_sql := pay_soe_util.genCursor || ' order by 2';
900: pay_soe_util.clear;
901: --
902: --
903: if g_debug then
896: name_count := name_count + 1;
897:
898: end loop;
899: l_sql := pay_soe_util.genCursor || ' order by 2';
900: pay_soe_util.clear;
901: --
902: --
903: if g_debug then
904: hr_utility.set_location('Leaving pay_za_soe.Balance_Details', 20);