APPS.HR_JP_ID_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 1905: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_ENTRIES_F%ROWTYPE

1901: p_assignment_id IN VARCHAR2,
1902: p_element_type_id IN VARCHAR2,
1903: p_entry_type IN VARCHAR2 DEFAULT 'E',
1904: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1905: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_ENTRIES_F%ROWTYPE
1906: --------------------------------------------------------------------------------
1907: IS
1908: l_rec PAY_ELEMENT_ENTRIES_F%ROWTYPE;
1909: CURSOR csr_element_entry(

Line 1908: l_rec PAY_ELEMENT_ENTRIES_F%ROWTYPE;

1904: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1905: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_ENTRIES_F%ROWTYPE
1906: --------------------------------------------------------------------------------
1907: IS
1908: l_rec PAY_ELEMENT_ENTRIES_F%ROWTYPE;
1909: CURSOR csr_element_entry(
1910: p_assignment_id NUMBER,
1911: p_element_type_id NUMBER) IS
1912: select pee.*

Line 1914: pay_element_entries_f pee

1910: p_assignment_id NUMBER,
1911: p_element_type_id NUMBER) IS
1912: select pee.*
1913: from pay_element_links_f pel,
1914: pay_element_entries_f pee
1915: where pee.assignment_id=p_assignment_id
1916: and pee.entry_type=p_entry_type
1917: and p_effective_date
1918: between pee.effective_start_date and pee.effective_end_date

Line 1949: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_ENTRIES_F%ROWTYPE

1945: p_element_name IN VARCHAR2,
1946: p_entry_type IN VARCHAR2 DEFAULT 'E',
1947: p_business_group_id IN NUMBER,
1948: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1949: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_ENTRIES_F%ROWTYPE
1950: --------------------------------------------------------------------------------
1951: IS
1952: l_assignment_id NUMBER := emp_assignment_id(p_assignment_number,p_business_group_id);
1953: l_element_type_id NUMBER := element_type_id(p_element_name,p_business_group_id);