APPS.HR_ADP dependencies on HR_ADP

Line 1: package body hr_adp as

1: package body hr_adp as
2: /* $Header: peadppkg.pkb 120.2 2005/10/28 04:21:43 sgelvi noship $ */
3: -----------------------------------------------------------------------
4: procedure set_adp_extract_date (p_adp_extract_date date,
5: p_ex_employee_months number default null,

Line 46: g_ex_employee_date := trunc(add_months(trunc(hr_adp.get_adp_extract_date),-g_ex_employee_months)

42: -- returns the sysdate as g_adp_extract_date is initialized to
43: -- sysdate.
44: --
45: begin
46: g_ex_employee_date := trunc(add_months(trunc(hr_adp.get_adp_extract_date),-g_ex_employee_months)
47: - to_char(trunc(hr_adp.get_adp_extract_date),'DD') +1);
48: g_ex_employee_date := nvl(g_ex_employee_date, to_date('01/01/0001','DD/MM/YYYY'));
49: RETURN g_ex_employee_date;
50: --

Line 47: - to_char(trunc(hr_adp.get_adp_extract_date),'DD') +1);

43: -- sysdate.
44: --
45: begin
46: g_ex_employee_date := trunc(add_months(trunc(hr_adp.get_adp_extract_date),-g_ex_employee_months)
47: - to_char(trunc(hr_adp.get_adp_extract_date),'DD') +1);
48: g_ex_employee_date := nvl(g_ex_employee_date, to_date('01/01/0001','DD/MM/YYYY'));
49: RETURN g_ex_employee_date;
50: --
51: end get_ex_employee_date;

Line 63: g_end_deduction_date := trunc(add_months(trunc(hr_adp.get_adp_extract_date),-g_end_deduction_months)

59: -- returns the sysdate as g_adp_extract_date is initialized to
60: -- sysdate.
61: --
62: begin
63: g_end_deduction_date := trunc(add_months(trunc(hr_adp.get_adp_extract_date),-g_end_deduction_months)
64: - to_char(trunc(hr_adp.get_adp_extract_date),'DD') +1) ;
65: g_end_deduction_date := nvl(g_end_deduction_date, to_date('01/01/0001','DD/MM/YYYY'));
66: RETURN g_end_deduction_date;
67: --

Line 64: - to_char(trunc(hr_adp.get_adp_extract_date),'DD') +1) ;

60: -- sysdate.
61: --
62: begin
63: g_end_deduction_date := trunc(add_months(trunc(hr_adp.get_adp_extract_date),-g_end_deduction_months)
64: - to_char(trunc(hr_adp.get_adp_extract_date),'DD') +1) ;
65: g_end_deduction_date := nvl(g_end_deduction_date, to_date('01/01/0001','DD/MM/YYYY'));
66: RETURN g_end_deduction_date;
67: --
68: end get_end_deduction_date;

Line 80: and trunc(hr_adp.get_adp_extract_date)

76: select max(priority)
77: into priority
78: from pay_personal_payment_methods_f
79: where assignment_id = p_assignment_id
80: and trunc(hr_adp.get_adp_extract_date)
81: between effective_start_date
82: and effective_end_date ;
83: return priority;
84: --

Line 87: end hr_adp;

83: return priority;
84: --
85: end get_max_ppm_priority;
86: --
87: end hr_adp;