DBA Data[Home] [Help]

APPS.PER_SSHR_CHANGE_PAY dependencies on PER_SALADMIN_UTILITY

Line 2663: 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

2659: hr_utility.set_location('No MULTIPLE_COMPONENTS '||l_prior_proposed_sal||l_proc, 25);
2660: end if;
2661: --
2662: if l_last_currency <> update_recs.input_currency_code then
2663: 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
2664: from dual;
2665: else
2666: l_xchg_rate := 1;
2667: end if;

Line 2686: 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

2682: --
2683: else
2684: --
2685: if l_last_currency <> update_recs.input_currency_code then
2686: 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
2687: from dual;
2688: else
2689: l_xchg_rate := 1;
2690: end if;

Line 2740: 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

2736: hr_utility.set_location(l_proc||'No MULTIPLE_COMPONENTS'||l_count, 25);
2737: end if;
2738: --
2739: if l_last_currency <> update_recs.input_currency_code then
2740: 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
2741: from dual;
2742: else
2743: l_xchg_rate := 1;
2744: end if;

Line 2762: 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

2758: hr_utility.set_location('Multiple Comp'||l_proc, 25);
2759: end if;
2760: --
2761: if l_last_currency <> update_recs.input_currency_code then
2762: 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
2763: from dual;
2764: else
2765: l_xchg_rate := 1;
2766: end if;

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

3941:
3942:
3943:
3944: --
3945: l_last_payroll_run_date := PER_SALADMIN_UTILITY.get_last_payroll_dt(p_assignment_id);
3946: if(l_last_payroll_run_date is null) then
3947: l_last_payroll_run_date := p_effective_date;
3948: l_payroll_attached := 'NO';
3949: end if;

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

4397: p_allow_basis_change := 'YES';
4398: l_payroll_attached := 'YES';
4399: l_proposals_exists := 'YES';
4400:
4401: l_last_payroll_run_date := PER_SALADMIN_UTILITY.get_last_payroll_dt(p_assignment_id);
4402:
4403: if g_debug then
4404: hr_utility.set_location('Selected p_effective_date '||p_effective_date, 10);
4405: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);

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

4752: --
4753: --
4754: --
4755: --
4756: l_assign_on_gsp := PER_SALADMIN_UTILITY.Check_GSP_Manual_Override(p_assignment_id,p_create_date);
4757:
4758: if l_assign_on_gsp = 'N' then
4759: p_allow_create := 'Y_GSP';
4760: return;

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

4953: p_basis_default_min_date := null;
4954: p_min_update_date := null;
4955: --
4956: --
4957: l_last_payroll_run_date := PER_SALADMIN_UTILITY.get_last_payroll_dt(p_assignment_id);
4958: if(l_last_payroll_run_date is null) then
4959: l_last_payroll_run_date := p_previous_date;
4960: l_payroll_attached := 'NO';
4961: end if;

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

5294: end if;
5295: close get_asg_hours;
5296:
5297: if l_hours_per_year is null then
5298: l_fte_factor := PER_SALADMIN_UTILITY.get_fte_factor(p_assignment_id,p_effective_date);
5299: RETURN l_fte_factor;
5300: end if;
5301:
5302: if(nvl(l_hours_per_year,0) <> 0) then