APPS.PAY_IN_TAX_DECLARATION dependencies on PER_PEOPLE_F

Line 46: -- IN : p_person_id per_people_f.person_id%TYPE --

42: -- freeze period details like start date, along with --
43: -- a flag to indicate if it is the freeze period. --
44: -- --
45: -- Parameters : --
46: -- IN : p_person_id per_people_f.person_id%TYPE --
47: -- OUT : p_locked VARCHAR2 --
48: -- p_lock_start DATE --
49: -- --
50: -- Change History : --

Line 62: (p_person_id IN per_people_f.person_id%TYPE

58: -- Modified the CURSOR --
59: -- csr_locking_period_details --
60: --------------------------------------------------------------------------
61: PROCEDURE is_locking_period
62: (p_person_id IN per_people_f.person_id%TYPE
63: ,p_locked OUT NOCOPY VARCHAR2
64: ,p_lock_start OUT NOCOPY DATE)
65: IS
66: --

Line 74: , per_people_f person

70: , nvl(org.org_information3, 0) window_period
71: , fnd_date.canonical_to_date(org.org_information2) locking_period_start
72: , TRUNC(SYSDATE - start_date) hire_duration
73: FROM hr_organization_information org
74: , per_people_f person
75: , per_assignments_f assign
76: , hr_soft_coding_keyflex scl
77: WHERE org.org_information_context = 'PER_IN_TAX_DECL_DETAILS'
78: AND person.person_id = c_person_id

Line 169: -- IN : p_person_id per_people_f.person_id%TYPE --

165: -- the flag stating if the employee tax declaration --
166: -- details have been approved or not. --
167: -- --
168: -- Parameters : --
169: -- IN : p_person_id per_people_f.person_id%TYPE --
170: -- p_effective_date DATE --
171: -- OUT : p_status VARCHAR2 --
172: -- --
173: -- Change History : --

Line 245: -- IN : p_person_id per_people_f.person_id%TYPE --

241: -- type of the primary address of the employee if the --
242: -- primary address is not available then return NA. --
243: -- --
244: -- Parameters : --
245: -- IN : p_person_id per_people_f.person_id%TYPE --
246: -- p_effective_date DATE --
247: -- RETURN : VARCHAR2 --
248: -- --
249: -- Change History : --