DBA Data[Home] [Help]

APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on PQP_EXTRACT_ATTRIBUTES

Line 1465: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type %TYPE;

1461: l_ele_type_id pay_element_types_f.element_type_id %TYPE;
1462: l_prev_ele_type_id pay_element_types_f.element_type_id %TYPE;
1463: l_valid_action Varchar2(2);
1464: bg_id per_all_assignments_f.business_group_id%TYPE;
1465: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type %TYPE;
1466: l_proc_name Varchar2(150) := g_proc_name ||'Create_Addl_Assignments';
1467: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1468: l_organization_id per_all_assignments_f.organization_id%TYPE;
1469: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

Line 1904: FROM pqp_extract_attributes

1900: -- ~ Type Of Extract(Full or Change)
1901: -- =========================================
1902: CURSOR csr_ext_attr (c_ext_dfn_id IN ben_ext_rslt.ext_dfn_id%TYPE) IS
1903: SELECT ext_dfn_type
1904: FROM pqp_extract_attributes
1905: WHERE ext_dfn_id = c_ext_dfn_id;
1906:
1907: -- Get the Conc. requests params based on the request id fetched
1908: CURSOR csr_ext_params (c_request_id IN Number

Line 2264: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE;

2260: -- ~ Local variables
2261: -- =========================================
2262: l_ext_params csr_ext_params%ROWTYPE;
2263: l_conc_reqest_id ben_ext_rslt.request_id%TYPE;
2264: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE;
2265: bg_id per_all_assignments_f.business_group_id%TYPE;
2266: l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;
2267: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
2268: l_return_value Varchar2(2) :='N';