APPS.PAY_JP_LTAX_IMP_PKG dependencies on PAY_JP_BALANCE_PKG

Line 825: and pay_jp_balance_pkg.get_entry_value_number(c_itx_org_iv_id,pa.assignment_id,ptp.regular_payment_date) = pjsn_act.organization_id

821: and ptp.regular_payment_date
822: between g_effective_som and g_effective_eom
823: and ptp.regular_payment_date
824: between pa.effective_start_date and pa.effective_end_date
825: and pay_jp_balance_pkg.get_entry_value_number(c_itx_org_iv_id,pa.assignment_id,ptp.regular_payment_date) = pjsn_act.organization_id
826: group by
827: pa.assignment_id,
828: pa.assignment_number,
829: nvl(pjsn_act.report_district_code,pjsn_act.district_code),

Line 1512: and pay_jp_balance_pkg.get_entry_value_number(c_itx_org_iv_id,pa.assignment_id,ptp.regular_payment_date) = hoi.organization_id);

1508: and hou.organization_id = hoi.organization_id
1509: and hoi.org_information_context = 'CLASS'
1510: and hoi.org_information1 = 'JP_TAX_SWOT'
1511: --exclude different itax are mixed in one file (swot_number should be different).
1512: and pay_jp_balance_pkg.get_entry_value_number(c_itx_org_iv_id,pa.assignment_id,ptp.regular_payment_date) = hoi.organization_id);
1513: --
1514: begin
1515: --
1516: if g_debug

Line 1683: l_non_res_date := pay_jp_balance_pkg.get_entry_value_date(c_non_res_date_iv_id,p_assignment_id,p_regular_payment_date);

1679: end if;
1680: --
1681: if l_valid then
1682: --
1683: l_non_res_date := pay_jp_balance_pkg.get_entry_value_date(c_non_res_date_iv_id,p_assignment_id,p_regular_payment_date);
1684: l_res_date := nvl(pay_jp_balance_pkg.get_entry_value_date(c_res_date_iv_id,p_assignment_id,p_regular_payment_date),hr_api.g_eot);
1685: --
1686: if g_debug
1687: and g_detail_debug = 'Y' then

Line 1684: l_res_date := nvl(pay_jp_balance_pkg.get_entry_value_date(c_res_date_iv_id,p_assignment_id,p_regular_payment_date),hr_api.g_eot);

1680: --
1681: if l_valid then
1682: --
1683: l_non_res_date := pay_jp_balance_pkg.get_entry_value_date(c_non_res_date_iv_id,p_assignment_id,p_regular_payment_date);
1684: l_res_date := nvl(pay_jp_balance_pkg.get_entry_value_date(c_res_date_iv_id,p_assignment_id,p_regular_payment_date),hr_api.g_eot);
1685: --
1686: if g_debug
1687: and g_detail_debug = 'Y' then
1688: hr_utility.set_location(l_proc,30);

Line 1705: l_non_res_flag := nvl(pay_jp_balance_pkg.get_entry_value_char(c_non_res_iv_id,p_assignment_id,p_regular_payment_date),'N');

1701: end if;
1702: --
1703: else
1704: --
1705: l_non_res_flag := nvl(pay_jp_balance_pkg.get_entry_value_char(c_non_res_iv_id,p_assignment_id,p_regular_payment_date),'N');
1706: --
1707: end if;
1708: --
1709: if g_debug