DBA Data[Home] [Help]

APPS.PAY_JP_IWHT_ARCH_PKG dependencies on HR_JP_ID_PKG

Line 1271: l_value := nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_MONEY',NULL,'JP')

1267: ln_term_ded_amt_spc := pay_jp_balance_pkg.get_balance_value(ln_def_balance_id_spc,lr_get_assact_bal.assignment_action_id);
1268:
1269: l_value := 0;
1270:
1271: l_value := nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_MONEY',NULL,'JP')
1272: ,lr_get_assact_bal.assignment_action_id),0)
1273: + nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_KIND',NULL,'JP')
1274: ,lr_get_assact_bal.assignment_action_id),0);
1275:

Line 1273: + nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_KIND',NULL,'JP')

1269: l_value := 0;
1270:
1271: l_value := nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_MONEY',NULL,'JP')
1272: ,lr_get_assact_bal.assignment_action_id),0)
1273: + nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_KIND',NULL,'JP')
1274: ,lr_get_assact_bal.assignment_action_id),0);
1275:
1276: IF ln_amt IS NOT NULL THEN
1277: IF l_value > 0 THEN

Line 1319: l_value := nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_MONEY_SPC_EXC',NULL,'JP')

1315:
1316: l_value := 0;
1317: lc_description_temp := '';
1318:
1319: l_value := nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_MONEY_SPC_EXC',NULL,'JP')
1320: ,ln_term_ass_act_id),0)
1321: + nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_KIND_SPC_EXC',NULL,'JP')
1322: ,ln_term_ass_act_id),0);
1323:

Line 1321: + nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_KIND_SPC_EXC',NULL,'JP')

1317: lc_description_temp := '';
1318:
1319: l_value := nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_MONEY_SPC_EXC',NULL,'JP')
1320: ,ln_term_ass_act_id),0)
1321: + nvl(pay_jp_balance_pkg.get_balance_value_asg_run(hr_jp_id_pkg.balance_type_id('B_TRM_TXBL_ERN_KIND_SPC_EXC',NULL,'JP')
1322: ,ln_term_ass_act_id),0);
1323:
1324: IF l_value > 0 THEN
1325: