DBA Data[Home] [Help]

APPS.PAY_KR_WG_PKG dependencies on PAY_KR_WG_REPORT_PKG

Line 51: l_attachment_seq_no := pay_kr_wg_report_pkg.get_attach_seq_no(p_element_entry_id);

47: l_return NUMBER := 0;
48: BEGIN
49: --
50: --
51: l_attachment_seq_no := pay_kr_wg_report_pkg.get_attach_seq_no(p_element_entry_id);
52:
53:
54: if g_debug then
55: hr_utility.set_location('Got the attachment seq no : '||l_attachment_seq_no, 10);

Line 1310: nvl(pay_kr_wg_report_pkg.paid_interest(p_assignment_id , g_court_orders(i).element_entry_id , p_date_earned ),0) ;

1306:
1307: -- Real Attachment Total = Attachment Total Base + Total Prepaid Interest + Interest this period
1308:
1309: g_court_orders(i).real_attach_total_by_creditor := g_court_orders(i).attachment_total_base + g_court_orders(i).interest_amount +
1310: nvl(pay_kr_wg_report_pkg.paid_interest(p_assignment_id , g_court_orders(i).element_entry_id , p_date_earned ),0) ;
1311:
1312: ELSE -- Interest Base Case
1313: --------------------------------------------------------------------------
1314: -- Attachment Total Base = Principal Base + Court Fee Base + Interest Base

Line 1455: nvl(pay_kr_wg_report_pkg.paid_amount(p_assignment_id , g_court_orders(i).element_entry_id, p_date_earned ),0);

1451:
1452: -- Employee attachment total = Real Attachment Total - Prepaid Debt
1453:
1454: g_court_orders(i).emp_attach_total_by_creditor := g_court_orders(i).real_attach_total_by_creditor -
1455: nvl(pay_kr_wg_report_pkg.paid_amount(p_assignment_id , g_court_orders(i).element_entry_id, p_date_earned ),0);
1456:
1457: -- Bug 2713144 Distribution Base = Real Attachment Total By Creditor
1458:
1459: g_court_orders(i).distribution_base := g_court_orders(i).real_attach_total_by_creditor;

Line 1466: nvl(pay_kr_wg_report_pkg.paid_amount(p_assignment_id , g_court_orders(i).element_entry_id, p_date_earned ),0);

1462:
1463: -- Employee attachment total = Real Attachment Total - Prepaid Debt -- Bug 2713144
1464:
1465: g_court_orders(i).emp_attach_total_by_creditor := g_court_orders(i).real_attach_total_by_creditor -
1466: nvl(pay_kr_wg_report_pkg.paid_amount(p_assignment_id , g_court_orders(i).element_entry_id, p_date_earned ),0);
1467:
1468: -- Bug 2713144 Distribution Base = Real Attachment Total
1469:
1470: g_court_orders(i).distribution_base := g_court_orders(i).real_attach_total_by_creditor;

Line 1520: g_court_orders(i).wg_adjustment_amount := nvl(pay_kr_wg_report_pkg.paid_amount(p_assignment_id, g_court_orders(i).element_entry_id, p_date_earned ),0);

1516: -- Redistrubution amount should be calcualted only if obligation release
1517: -- has not earlier been processed.
1518: --
1519: IF g_court_orders(i).obligation_release_processed = 'N' THEN -- 4866417
1520: g_court_orders(i).wg_adjustment_amount := nvl(pay_kr_wg_report_pkg.paid_amount(p_assignment_id, g_court_orders(i).element_entry_id, p_date_earned ),0);
1521: g_emp_total.wg_adjustment := g_emp_total.wg_adjustment + g_court_orders(i).wg_adjustment_amount;
1522: END IF;
1523: --
1524: if g_debug then