DBA Data[Home] [Help]

APPS.PER_SSHR_CHANGE_PAY dependencies on PER_SALADMIN_UTILITY

Line 2694: select PER_SALADMIN_UTILITY.get_currency_rate(l_last_currency,update_recs.input_currency_code,update_recs.change_date,p_busgroup_id) into l_xchg_rate

2690: hr_utility.set_location('No MULTIPLE_COMPONENTS '||l_prior_proposed_sal||l_proc, 25);
2691: end if;
2692: --
2693: if l_last_currency <> update_recs.input_currency_code then
2694: select PER_SALADMIN_UTILITY.get_currency_rate(l_last_currency,update_recs.input_currency_code,update_recs.change_date,p_busgroup_id) into l_xchg_rate
2695: from dual;
2696: else
2697: l_xchg_rate := 1;
2698: end if;

Line 2717: select PER_SALADMIN_UTILITY.get_currency_rate(l_last_currency,update_recs.input_currency_code,update_recs.change_date,p_busgroup_id) into l_xchg_rate

2713: --
2714: else
2715: --
2716: if l_last_currency <> update_recs.input_currency_code then
2717: select PER_SALADMIN_UTILITY.get_currency_rate(l_last_currency,update_recs.input_currency_code,update_recs.change_date,p_busgroup_id) into l_xchg_rate
2718: from dual;
2719: else
2720: l_xchg_rate := 1;
2721: end if;

Line 2771: select PER_SALADMIN_UTILITY.get_currency_rate(l_last_currency,update_recs.input_currency_code,update_recs.change_date,p_busgroup_id) into l_xchg_rate

2767: hr_utility.set_location(l_proc||'No MULTIPLE_COMPONENTS'||l_count, 25);
2768: end if;
2769: --
2770: if l_last_currency <> update_recs.input_currency_code then
2771: select PER_SALADMIN_UTILITY.get_currency_rate(l_last_currency,update_recs.input_currency_code,update_recs.change_date,p_busgroup_id) into l_xchg_rate
2772: from dual;
2773: else
2774: l_xchg_rate := 1;
2775: end if;

Line 2793: select PER_SALADMIN_UTILITY.get_currency_rate(l_last_currency,update_recs.input_currency_code,update_recs.change_date,p_busgroup_id) into l_xchg_rate

2789: hr_utility.set_location('Multiple Comp'||l_proc, 25);
2790: end if;
2791: --
2792: if l_last_currency <> update_recs.input_currency_code then
2793: select PER_SALADMIN_UTILITY.get_currency_rate(l_last_currency,update_recs.input_currency_code,update_recs.change_date,p_busgroup_id) into l_xchg_rate
2794: from dual;
2795: else
2796: l_xchg_rate := 1;
2797: end if;

Line 4077: l_last_payroll_run_date := PER_SALADMIN_UTILITY.get_last_payroll_dt(p_assignment_id);

4073:
4074:
4075:
4076: --
4077: l_last_payroll_run_date := PER_SALADMIN_UTILITY.get_last_payroll_dt(p_assignment_id);
4078: if(l_last_payroll_run_date is null) then
4079: l_last_payroll_run_date := p_effective_date;
4080: l_payroll_attached := 'NO';
4081: end if;

Line 4537: l_last_payroll_run_date := PER_SALADMIN_UTILITY.get_last_payroll_dt(p_assignment_id);

4533: p_allow_basis_change := 'YES';
4534: l_payroll_attached := 'YES';
4535: l_proposals_exists := 'YES';
4536:
4537: l_last_payroll_run_date := PER_SALADMIN_UTILITY.get_last_payroll_dt(p_assignment_id);
4538:
4539: if g_debug then
4540: hr_utility.set_location('Selected p_effective_date '||p_effective_date, 10);
4541: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);

Line 4892: l_assign_on_gsp := PER_SALADMIN_UTILITY.Check_GSP_Manual_Override(p_assignment_id,p_create_date);

4888: --
4889: --
4890: --
4891: --
4892: l_assign_on_gsp := PER_SALADMIN_UTILITY.Check_GSP_Manual_Override(p_assignment_id,p_create_date);
4893:
4894: if l_assign_on_gsp = 'N' then
4895: p_allow_create := 'Y_GSP';
4896: return;

Line 5095: l_last_payroll_run_date := PER_SALADMIN_UTILITY.get_last_payroll_dt(p_assignment_id);

5091: p_basis_default_min_date := null;
5092: p_min_update_date := null;
5093: --
5094: --
5095: l_last_payroll_run_date := PER_SALADMIN_UTILITY.get_last_payroll_dt(p_assignment_id);
5096: if(l_last_payroll_run_date is null) then
5097: l_last_payroll_run_date := p_previous_date;
5098: l_payroll_attached := 'NO';
5099: end if;

Line 5439: l_fte_factor := PER_SALADMIN_UTILITY.get_fte_factor(p_assignment_id,p_effective_date);

5435: end if;
5436: close get_asg_hours;
5437: --vkodedal 8593436 30-Jun-2009 added or condition
5438: if l_hours_per_year is null OR l_eff_date > p_effective_date then
5439: l_fte_factor := PER_SALADMIN_UTILITY.get_fte_factor(p_assignment_id,p_effective_date);
5440: RETURN l_fte_factor;
5441: end if;
5442:
5443: if(nvl(l_hours_per_year,0) <> 0) then