DBA Data[Home] [Help]

APPS.PAY_CN_DEDUCTIONS dependencies on PAY_BALANCE_PKG

Line 2447: ,p_balance_value_tab OUT NOCOPY pay_balance_pkg.t_balance_value_tab

2443: (p_phf_si_type IN VARCHAR2
2444: ,p_assignment_action_id IN NUMBER
2445: ,p_tax_unit_id IN NUMBER
2446: ,p_date_earned IN DATE
2447: ,p_balance_value_tab OUT NOCOPY pay_balance_pkg.t_balance_value_tab
2448: )
2449: IS
2450:
2451: CURSOR c_element_name is

Line 2520: pay_balance_pkg.get_value

2516:
2517: FOR cnt in p_balance_value_tab.first .. p_balance_value_tab.last
2518: LOOP
2519: p_balance_value_tab(cnt).balance_value :=
2520: pay_balance_pkg.get_value
2521: (p_defined_balance_id => p_balance_value_tab(cnt).defined_balance_id
2522: ,p_assignment_action_id => p_assignment_action_id
2523: ,p_tax_unit_id => p_tax_unit_id
2524: ,p_jurisdiction_code => NULL

Line 3810: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));

3806:
3807: --
3808: -- Step 1: Get the various DBIs
3809: --
3810: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
3811: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
3812:
3813: l_actual_probation_end_date:= fnd_date.canonical_to_date(
3814: pay_balance_pkg.run_db_item('CTR_CN_ACTUAL_PROBATION_END_DATE',p_business_group_id,'CN'));

Line 3811: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);

3807: --
3808: -- Step 1: Get the various DBIs
3809: --
3810: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
3811: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
3812:
3813: l_actual_probation_end_date:= fnd_date.canonical_to_date(
3814: pay_balance_pkg.run_db_item('CTR_CN_ACTUAL_PROBATION_END_DATE',p_business_group_id,'CN'));
3815:

Line 3814: pay_balance_pkg.run_db_item('CTR_CN_ACTUAL_PROBATION_END_DATE',p_business_group_id,'CN'));

3810: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
3811: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
3812:
3813: l_actual_probation_end_date:= fnd_date.canonical_to_date(
3814: pay_balance_pkg.run_db_item('CTR_CN_ACTUAL_PROBATION_END_DATE',p_business_group_id,'CN'));
3815:
3816: l_const_probation_end_date:= fnd_date.canonical_to_date(
3817: pay_balance_pkg.run_db_item('CTR_CN_CONST_PROBATION_END_DATE',p_business_group_id,'CN'));
3818:

Line 3817: pay_balance_pkg.run_db_item('CTR_CN_CONST_PROBATION_END_DATE',p_business_group_id,'CN'));

3813: l_actual_probation_end_date:= fnd_date.canonical_to_date(
3814: pay_balance_pkg.run_db_item('CTR_CN_ACTUAL_PROBATION_END_DATE',p_business_group_id,'CN'));
3815:
3816: l_const_probation_end_date:= fnd_date.canonical_to_date(
3817: pay_balance_pkg.run_db_item('CTR_CN_CONST_PROBATION_END_DATE',p_business_group_id,'CN'));
3818:
3819: l_defer_deductions := pay_balance_pkg.run_db_item('PER_EMPLOYER_INFO_CN_ORG_DEFER_DEDUCTIONS',p_business_group_id,'CN');
3820:
3821: l_deduct_in_probation_expiry := pay_balance_pkg.run_db_item('PER_EMPLOYER_INFO_CN_ORG_DEDUCT_IN_PROBATION_EXPIRY',p_business_group_id,'CN');

Line 3819: l_defer_deductions := pay_balance_pkg.run_db_item('PER_EMPLOYER_INFO_CN_ORG_DEFER_DEDUCTIONS',p_business_group_id,'CN');

3815:
3816: l_const_probation_end_date:= fnd_date.canonical_to_date(
3817: pay_balance_pkg.run_db_item('CTR_CN_CONST_PROBATION_END_DATE',p_business_group_id,'CN'));
3818:
3819: l_defer_deductions := pay_balance_pkg.run_db_item('PER_EMPLOYER_INFO_CN_ORG_DEFER_DEDUCTIONS',p_business_group_id,'CN');
3820:
3821: l_deduct_in_probation_expiry := pay_balance_pkg.run_db_item('PER_EMPLOYER_INFO_CN_ORG_DEDUCT_IN_PROBATION_EXPIRY',p_business_group_id,'CN');
3822:
3823: l_message := get_phf_si_deferred_amounts

Line 3821: l_deduct_in_probation_expiry := pay_balance_pkg.run_db_item('PER_EMPLOYER_INFO_CN_ORG_DEDUCT_IN_PROBATION_EXPIRY',p_business_group_id,'CN');

3817: pay_balance_pkg.run_db_item('CTR_CN_CONST_PROBATION_END_DATE',p_business_group_id,'CN'));
3818:
3819: l_defer_deductions := pay_balance_pkg.run_db_item('PER_EMPLOYER_INFO_CN_ORG_DEFER_DEDUCTIONS',p_business_group_id,'CN');
3820:
3821: l_deduct_in_probation_expiry := pay_balance_pkg.run_db_item('PER_EMPLOYER_INFO_CN_ORG_DEDUCT_IN_PROBATION_EXPIRY',p_business_group_id,'CN');
3822:
3823: l_message := get_phf_si_deferred_amounts
3824: (p_pay_proc_period_end_date => p_pay_proc_period_end_date
3825: ,p_actual_probation_end_date => NVL(l_actual_probation_end_date,g_start_date)