APPS.PQP_US_PENSION_EXTRACTS dependencies on PQP_EXTRACT_ATTRIBUTES

Line 3083: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE;

3079: l_RothER_Element_id pay_element_types_f.element_type_id%TYPE;
3080: l_ATER_Element_id pay_element_types_f.element_type_id%TYPE;
3081: l_ER_element_id pay_element_types_f.element_type_id%TYPE;
3082:
3083: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE;
3084: BEGIN
3085: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
3086: -- If element set was selected
3087: l_ext_dfn_type := g_extract_params(p_business_group_id).ext_dfn_type;

Line 3523: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE;

3519: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
3520: l_valid_action VARCHAR2(2);
3521: l_ele_count NUMBER(10);
3522: i per_all_assignments_f.business_group_id%TYPE;
3523: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE;
3524: l_proc_name VARCHAR2(150) := g_proc_name ||'Process_Assignments';
3525: BEGIN
3526: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
3527: i := p_business_group_id;

Line 4895: FROM pqp_extract_attributes

4891: -- =========================================
4892:
4893: CURSOR csr_ext_attr (c_ext_dfn_id IN ben_ext_rslt.ext_dfn_id%TYPE) IS
4894: SELECT ext_dfn_type
4895: FROM pqp_extract_attributes
4896: WHERE ext_dfn_id = c_ext_dfn_id;
4897:
4898: -- Get the Conc. requests params based on the request id fetched
4899: CURSOR csr_ext_params (c_request_id IN NUMBER

Line 5015: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE;

5011: -- ~ Local variables
5012: -- =========================================
5013: l_ext_params csr_ext_params%ROWTYPE;
5014: l_conc_reqest_id ben_ext_rslt.request_id%TYPE;
5015: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE;
5016: i per_all_assignments_f.business_group_id%TYPE;
5017: l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;
5018: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
5019: l_return_value VARCHAR2(2) :='N';