APPS.PQP_GB_OMP_TEMPLATE dependencies on PAY_ELEMENT_LINKS_F

Line 2348: l_element_link_id pay_element_links_f.element_link_id%TYPE ;

2344: ) IS
2345: -- l_link_ele_name t_ele_name ;
2346: l_element_type_id pay_element_types_f.element_type_id%TYPE ;
2347: l_rowid VARCHAR2(100) ;
2348: l_element_link_id pay_element_links_f.element_link_id%TYPE ;
2349: l_effective_end_date DATE := p_effective_end_date ;
2350:
2351: --CURSOR csr_get_element_type_id (p_element_name IN VARCHAR2 ) IS
2352: --SELECT element_type_id

Line 2476: l_element_link_id pay_element_links_f.element_link_id%TYPE ;

2472:
2473: --l_link_ele_name t_ele_name ;
2474: --l_element_type_id pay_element_types_f.element_type_id%TYPE ;
2475: l_rowid VARCHAR2(100) ;
2476: l_element_link_id pay_element_links_f.element_link_id%TYPE ;
2477: l_people_group_id pay_element_links_f.people_group_id%TYPE ;
2478: l_effective_end_date DATE := p_effective_end_date ;
2479:
2480: -- CURSOR csr_get_element_type_id (p_element_name IN VARCHAR2 ) IS

Line 2477: l_people_group_id pay_element_links_f.people_group_id%TYPE ;

2473: --l_link_ele_name t_ele_name ;
2474: --l_element_type_id pay_element_types_f.element_type_id%TYPE ;
2475: l_rowid VARCHAR2(100) ;
2476: l_element_link_id pay_element_links_f.element_link_id%TYPE ;
2477: l_people_group_id pay_element_links_f.people_group_id%TYPE ;
2478: l_effective_end_date DATE := p_effective_end_date ;
2479:
2480: -- CURSOR csr_get_element_type_id (p_element_name IN VARCHAR2 ) IS
2481: --SELECT element_type_id

Line 2487: FROM pay_element_links_f

2483: --WHERE element_name = p_element_name ;
2484:
2485: CURSOR csr_link_details ( p_element_type_id IN NUMBER ) IS
2486: SELECT rowid, element_link_id, people_group_id
2487: FROM pay_element_links_f
2488: WHERE element_type_id = p_element_type_id ;
2489:
2490: -- CURSOR csr_get_element_name(p_element_type_id NUMBER)
2491: -- IS