APPS.PQP_NL_SAVINGS_TEMPLATE dependencies on PQP_PENSION_TYPES_F

Line 408: l_ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%type;

404: l_configuration_information18 VARCHAR2(10) := 'N' ;
405: l_configuration_information19 VARCHAR2(10) := 'N' ;
406: l_configuration_information20 VARCHAR2(10) := 'N' ;
407:
408: l_ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%type;
409: l_er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%type;
410: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;
411: l_row_id rowid;
412: l_request_id Number;

Line 409: l_er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%type;

405: l_configuration_information19 VARCHAR2(10) := 'N' ;
406: l_configuration_information20 VARCHAR2(10) := 'N' ;
407:
408: l_ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%type;
409: l_er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%type;
410: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;
411: l_row_id rowid;
412: l_request_id Number;
413: l_er_request_id Number;

Line 462: from pqp_pension_types_f

458: --
459: cursor csr_pty (c_pension_type_id number
460: ,c_effective_date date) is
461: select ee_contribution_bal_type_id
462: from pqp_pension_types_f
463: where pension_type_id = c_pension_type_id
464: and business_group_id = p_business_group_id
465: and c_effective_date between effective_start_date
466: and effective_end_date;

Line 471: from pqp_pension_types_f

467:
468: cursor csr_pty1 (c_pension_type_id number
469: ,c_effective_date date) is
470: select *
471: from pqp_pension_types_f
472: where pension_type_id = c_pension_type_id
473: and business_group_id = p_business_group_id
474: and c_effective_date between effective_start_date
475: and effective_end_date;

Line 480: from pqp_pension_types_f

476:
477: cursor csr_pty2 (c_pension_type_id number
478: ,c_effective_date date) is
479: select er_contribution_bal_type_id
480: from pqp_pension_types_f
481: where pension_type_id = c_pension_type_id
482: and business_group_id = p_business_group_id
483: and c_effective_date between effective_start_date
484: and effective_end_date;

Line 487: r_pty_rec pqp_pension_types_f%ROWTYPE;

483: and c_effective_date between effective_start_date
484: and effective_end_date;
485:
486:
487: r_pty_rec pqp_pension_types_f%ROWTYPE;
488:
489:
490: cursor csr_get_formula_txt (c_formula_id number) is
491: select formula_text