APPS.PAY_IE_PENSION_TEMPLATE dependencies on PQP_PENSION_TYPES_F

Line 530: l_ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%type;

526:
527: -- Extra Information variables
528: l_eei_information1 pay_element_type_extra_info.eei_information1%type;
529: l_eei_information2 pay_element_type_extra_info.eei_information2%type;
530: l_ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%type;
531: l_er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%type;
532: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;
533: l_row_id rowid;
534: l_request_id Number;

Line 531: l_er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%type;

527: -- Extra Information variables
528: l_eei_information1 pay_element_type_extra_info.eei_information1%type;
529: l_eei_information2 pay_element_type_extra_info.eei_information2%type;
530: l_ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%type;
531: l_er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%type;
532: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;
533: l_row_id rowid;
534: l_request_id Number;
535: l_er_request_id Number;

Line 544: from pqp_pension_types_f

540: --
541: cursor csr_get_category (c_pen_type_id number,
542: c_effective_date date) is
543: select pension_category
544: from pqp_pension_types_f
545: where pension_type_id = c_pen_type_id
546: and c_effective_date between effective_start_date and effective_end_date;
547:
548: cursor csr_get_ee_bal_info (c_bal_name varchar2) is

Line 599: from pqp_pension_types_f

595: --
596: cursor csr_pty (c_pension_type_id number
597: ,c_effective_date date) is
598: select ee_contribution_bal_type_id
599: from pqp_pension_types_f
600: where pension_type_id = c_pension_type_id
601: and business_group_id = p_business_group_id
602: and c_effective_date between effective_start_date
603: and effective_end_date;

Line 608: from pqp_pension_types_f

604:
605: cursor csr_pty1 (c_pension_type_id number
606: ,c_effective_date date) is
607: select *
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_pty2 (c_pension_type_id number
615: ,c_effective_date date) is
616: select er_contribution_bal_type_id
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 623: r_pty_rec pqp_pension_types_f%ROWTYPE;

619: and business_group_id = p_business_group_id
620: and c_effective_date between effective_start_date
621: and effective_end_date;
622:
623: r_pty_rec pqp_pension_types_f%ROWTYPE;
624:
625:
626: l_scheme_dummy varchar2(10);
627: -- ---------------------------------------------------------------------