APPS.HR_JP_ID_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 1913: from pay_element_links_f pel,

1909: CURSOR csr_element_entry(
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

Line 2169: P_ERROR_WHEN_NOT_EXIST IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_LINKS_F%ROWTYPE

2165: P_LINK_TO_ALL_PAYROLLS_FLAG IN VARCHAR2 DEFAULT 'N',
2166: P_PAY_BASIS_ID IN NUMBER DEFAULT NULL,
2167: P_BUSINESS_GROUP_ID IN NUMBER,
2168: P_EFFECTIVE_DATE IN DATE DEFAULT hr_api.g_sys,
2169: P_ERROR_WHEN_NOT_EXIST IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_LINKS_F%ROWTYPE
2170: --------------------------------------------------------------------------------
2171: IS
2172: l_unique_column_tbl UniColTbl;
2173: l_csr RefCsr;

Line 2174: l_rec PAY_ELEMENT_LINKS_F%ROWTYPE;

2170: --------------------------------------------------------------------------------
2171: IS
2172: l_unique_column_tbl UniColTbl;
2173: l_csr RefCsr;
2174: l_rec PAY_ELEMENT_LINKS_F%ROWTYPE;
2175: BEGIN
2176: unique_tbl_constructor('ELEMENT_TYPE_ID','N',to_char(p_element_type_id),l_unique_column_tbl);
2177: unique_tbl_constructor('ORGANIZATION_ID','N',to_char(p_organization_id),l_unique_column_tbl);
2178: unique_tbl_constructor('PEOPLE_GROUP_ID','N',to_char(p_people_group_id),l_unique_column_tbl);

Line 2188: l_csr := csr('PAY_ELEMENT_LINKS_F',l_unique_column_tbl,'DATETRACKED',p_effective_date);

2184: unique_tbl_constructor('PAYROLL_ID','N',to_char(p_payroll_id),l_unique_column_tbl);
2185: unique_tbl_constructor('LINK_TO_ALL_PAYROLLS_FLAG','T',p_link_to_all_payrolls_flag,l_unique_column_tbl);
2186: unique_tbl_constructor('PAY_BASIS_ID','N',to_char(p_pay_basis_id),l_unique_column_tbl);
2187: unique_tbl_constructor('BUSINESS_GROUP_ID + 0','N',to_char(p_business_group_id),l_unique_column_tbl);
2188: l_csr := csr('PAY_ELEMENT_LINKS_F',l_unique_column_tbl,'DATETRACKED',p_effective_date);
2189: fetch l_csr into l_rec;
2190: if l_csr%NOTFOUND then
2191: if p_error_when_not_exist = 'TRUE' then
2192: close l_csr;