eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_NL_ABP_TEMPLATE dependencies on PQP_PENSION_TYPES_F

Line 97: pqp_pension_types_f.ee_contribution_bal_type_id%TYPE;

93: l_configuration_information8 VARCHAR2(10) := 'N' ;
94: l_configuration_information9 VARCHAR2(10) := 'N' ;
95: l_configuration_information10 VARCHAR2(10) := 'N' ;
96: l_ee_contribution_bal_type_id
97: pqp_pension_types_f.ee_contribution_bal_type_id%TYPE;
98: l_er_contribution_bal_type_id
99: pqp_pension_types_f.er_contribution_bal_type_id%TYPE;
100: l_ee_retro_bal_id pay_balance_types.balance_type_id%TYPE;
101: l_er_retro_bal_id pay_balance_types.balance_type_id%TYPE;

Line 99: pqp_pension_types_f.er_contribution_bal_type_id%TYPE;

95: l_configuration_information10 VARCHAR2(10) := 'N' ;
96: l_ee_contribution_bal_type_id
97: pqp_pension_types_f.ee_contribution_bal_type_id%TYPE;
98: l_er_contribution_bal_type_id
99: pqp_pension_types_f.er_contribution_bal_type_id%TYPE;
100: l_ee_retro_bal_id pay_balance_types.balance_type_id%TYPE;
101: l_er_retro_bal_id pay_balance_types.balance_type_id%TYPE;
102: l_pen_sal_bal_type_id
103: pqp_pension_types_f.pension_salary_balance%TYPE := -1;

Line 103: pqp_pension_types_f.pension_salary_balance%TYPE := -1;

99: pqp_pension_types_f.er_contribution_bal_type_id%TYPE;
100: l_ee_retro_bal_id pay_balance_types.balance_type_id%TYPE;
101: l_er_retro_bal_id pay_balance_types.balance_type_id%TYPE;
102: l_pen_sal_bal_type_id
103: pqp_pension_types_f.pension_salary_balance%TYPE := -1;
104: l_balance_feed_Id
105: pay_balance_feeds_f.balance_feed_id%TYPE;
106: l_row_id ROWID;
107: l_request_id NUMBER;

Line 146: l_pension_sub_category pqp_pension_types_f.pension_sub_category%TYPE;

142: l_shad_formula_id1 NUMBER;
143: l_prem_replace_string VARCHAR2(5000) := ' ' ;
144: l_std_link_flag VARCHAR2(10) := 'N';
145: l_scheme_prefix VARCHAR2(50) := p_scheme_prefix;
146: l_pension_sub_category pqp_pension_types_f.pension_sub_category%TYPE;
147: l_subcat VARCHAR2(30);
148: l_conversion_rule
149: pqp_pension_types_f.threshold_conversion_rule%TYPE;
150: l_basis_method pqp_pension_types_f.pension_basis_calc_method%TYPE;

Line 149: pqp_pension_types_f.threshold_conversion_rule%TYPE;

145: l_scheme_prefix VARCHAR2(50) := p_scheme_prefix;
146: l_pension_sub_category pqp_pension_types_f.pension_sub_category%TYPE;
147: l_subcat VARCHAR2(30);
148: l_conversion_rule
149: pqp_pension_types_f.threshold_conversion_rule%TYPE;
150: l_basis_method pqp_pension_types_f.pension_basis_calc_method%TYPE;
151:
152: --
153: CURSOR csr_get_ele_info (c_ele_name VARCHAR2) IS

Line 150: l_basis_method pqp_pension_types_f.pension_basis_calc_method%TYPE;

146: l_pension_sub_category pqp_pension_types_f.pension_sub_category%TYPE;
147: l_subcat VARCHAR2(30);
148: l_conversion_rule
149: pqp_pension_types_f.threshold_conversion_rule%TYPE;
150: l_basis_method pqp_pension_types_f.pension_basis_calc_method%TYPE;
151:
152: --
153: CURSOR csr_get_ele_info (c_ele_name VARCHAR2) IS
154: SELECT element_type_id

Line 186: FROM pqp_pension_types_f

182: --
183: CURSOR csr_pty1 (c_pension_type_id NUMBER
184: ,c_effective_date date) IS
185: SELECT *
186: FROM pqp_pension_types_f
187: WHERE pension_type_id = c_pension_type_id
188: AND business_group_id = p_business_group_id
189: AND c_effective_date BETWEEN effective_start_date
190: AND effective_end_date;

Line 192: r_pty_rec pqp_pension_types_f%ROWTYPE;

188: AND business_group_id = p_business_group_id
189: AND c_effective_date BETWEEN effective_start_date
190: AND effective_end_date;
191:
192: r_pty_rec pqp_pension_types_f%ROWTYPE;
193:
194: CURSOR csr_get_formula_txt (c_formula_id NUMBER) IS
195: SELECT formula_text
196: FROM pay_shadow_formulas

Line 574: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE

570: -- ---------------------------------------------------------------------
571: PROCEDURE chk_scheme_validity
572: ( p_scheme_start_date IN DATE
573: ,p_scheme_end_date IN DATE
574: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE
575: ,p_pension_sub_category IN pqp_pension_types_f.pension_sub_category%TYPE
576: ,p_conversion_rule IN pqp_pension_types_f.threshold_conversion_rule%TYPE
577: ,p_pension_basis_method IN pqp_pension_types_f.pension_basis_calc_method%TYPE
578: ,p_business_group_id IN NUMBER)

Line 575: ,p_pension_sub_category IN pqp_pension_types_f.pension_sub_category%TYPE

571: PROCEDURE chk_scheme_validity
572: ( p_scheme_start_date IN DATE
573: ,p_scheme_end_date IN DATE
574: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE
575: ,p_pension_sub_category IN pqp_pension_types_f.pension_sub_category%TYPE
576: ,p_conversion_rule IN pqp_pension_types_f.threshold_conversion_rule%TYPE
577: ,p_pension_basis_method IN pqp_pension_types_f.pension_basis_calc_method%TYPE
578: ,p_business_group_id IN NUMBER)
579: IS

Line 576: ,p_conversion_rule IN pqp_pension_types_f.threshold_conversion_rule%TYPE

572: ( p_scheme_start_date IN DATE
573: ,p_scheme_end_date IN DATE
574: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE
575: ,p_pension_sub_category IN pqp_pension_types_f.pension_sub_category%TYPE
576: ,p_conversion_rule IN pqp_pension_types_f.threshold_conversion_rule%TYPE
577: ,p_pension_basis_method IN pqp_pension_types_f.pension_basis_calc_method%TYPE
578: ,p_business_group_id IN NUMBER)
579: IS
580: --

Line 577: ,p_pension_basis_method IN pqp_pension_types_f.pension_basis_calc_method%TYPE

573: ,p_scheme_end_date IN DATE
574: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE
575: ,p_pension_sub_category IN pqp_pension_types_f.pension_sub_category%TYPE
576: ,p_conversion_rule IN pqp_pension_types_f.threshold_conversion_rule%TYPE
577: ,p_pension_basis_method IN pqp_pension_types_f.pension_basis_calc_method%TYPE
578: ,p_business_group_id IN NUMBER)
579: IS
580: --
581: l_proc_name VARCHAR2(80) := g_proc_name ||

Line 641: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE

637: -- ---------------------------------------------------------------------
638: PROCEDURE create_abp_formula_results
639: ( p_scheme_start_date IN DATE
640: ,p_scheme_end_date IN DATE
641: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE
642: ,p_pension_sub_category IN pqp_pension_types_f.pension_sub_category%TYPE
643: ,p_conversion_rule IN pqp_pension_types_f.threshold_conversion_rule%TYPE
644: ,p_pension_basis_method IN pqp_pension_types_f.pension_basis_calc_method%TYPE
645: ,p_abp_element_type_id IN NUMBER

Line 642: ,p_pension_sub_category IN pqp_pension_types_f.pension_sub_category%TYPE

638: PROCEDURE create_abp_formula_results
639: ( p_scheme_start_date IN DATE
640: ,p_scheme_end_date IN DATE
641: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE
642: ,p_pension_sub_category IN pqp_pension_types_f.pension_sub_category%TYPE
643: ,p_conversion_rule IN pqp_pension_types_f.threshold_conversion_rule%TYPE
644: ,p_pension_basis_method IN pqp_pension_types_f.pension_basis_calc_method%TYPE
645: ,p_abp_element_type_id IN NUMBER
646: ,p_business_group_id IN NUMBER

Line 643: ,p_conversion_rule IN pqp_pension_types_f.threshold_conversion_rule%TYPE

639: ( p_scheme_start_date IN DATE
640: ,p_scheme_end_date IN DATE
641: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE
642: ,p_pension_sub_category IN pqp_pension_types_f.pension_sub_category%TYPE
643: ,p_conversion_rule IN pqp_pension_types_f.threshold_conversion_rule%TYPE
644: ,p_pension_basis_method IN pqp_pension_types_f.pension_basis_calc_method%TYPE
645: ,p_abp_element_type_id IN NUMBER
646: ,p_business_group_id IN NUMBER
647: ,p_employer_component IN VARCHAR2

Line 644: ,p_pension_basis_method IN pqp_pension_types_f.pension_basis_calc_method%TYPE

640: ,p_scheme_end_date IN DATE
641: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE
642: ,p_pension_sub_category IN pqp_pension_types_f.pension_sub_category%TYPE
643: ,p_conversion_rule IN pqp_pension_types_f.threshold_conversion_rule%TYPE
644: ,p_pension_basis_method IN pqp_pension_types_f.pension_basis_calc_method%TYPE
645: ,p_abp_element_type_id IN NUMBER
646: ,p_business_group_id IN NUMBER
647: ,p_employer_component IN VARCHAR2
648: )