APPS.PAY_IE_PENSION_TEMPLATE dependencies on PQP_PENSION_TYPES_F

Line 539: l_ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%type;

535:
536: -- Extra Information variables
537: l_eei_information1 pay_element_type_extra_info.eei_information1%type;
538: l_eei_information2 pay_element_type_extra_info.eei_information2%type;
539: l_ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%type;
540: l_er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%type;
541: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;
542: l_row_id rowid;
543: l_request_id Number;

Line 540: l_er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%type;

536: -- Extra Information variables
537: l_eei_information1 pay_element_type_extra_info.eei_information1%type;
538: l_eei_information2 pay_element_type_extra_info.eei_information2%type;
539: l_ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%type;
540: l_er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%type;
541: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;
542: l_row_id rowid;
543: l_request_id Number;
544: l_er_request_id Number;

Line 553: from pqp_pension_types_f

549: --
550: cursor csr_get_category (c_pen_type_id number,
551: c_effective_date date) is
552: select pension_category
553: from pqp_pension_types_f
554: where pension_type_id = c_pen_type_id
555: and c_effective_date between effective_start_date and effective_end_date;
556:
557: cursor csr_get_ee_bal_info (c_bal_name varchar2) is

Line 608: from pqp_pension_types_f

604: --
605: cursor csr_pty (c_pension_type_id number
606: ,c_effective_date date) is
607: select ee_contribution_bal_type_id
608: from pqp_pension_types_f
609: where pension_type_id = c_pension_type_id
610: and business_group_id = p_business_group_id
611: and c_effective_date between effective_start_date
612: and effective_end_date;

Line 617: from pqp_pension_types_f

613:
614: cursor csr_pty1 (c_pension_type_id number
615: ,c_effective_date date) is
616: select *
617: from pqp_pension_types_f
618: where pension_type_id = c_pension_type_id
619: and business_group_id = p_business_group_id
620: and c_effective_date between effective_start_date
621: and effective_end_date;

Line 626: from pqp_pension_types_f

622:
623: cursor csr_pty2 (c_pension_type_id number
624: ,c_effective_date date) is
625: select er_contribution_bal_type_id
626: from pqp_pension_types_f
627: where pension_type_id = c_pension_type_id
628: and business_group_id = p_business_group_id
629: and c_effective_date between effective_start_date
630: and effective_end_date;

Line 632: r_pty_rec pqp_pension_types_f%ROWTYPE;

628: and business_group_id = p_business_group_id
629: and c_effective_date between effective_start_date
630: and effective_end_date;
631:
632: r_pty_rec pqp_pension_types_f%ROWTYPE;
633:
634:
635: l_scheme_dummy varchar2(10);
636: -- ---------------------------------------------------------------------