APPS.PQP_NL_PENSION_TEMPLATE dependencies on PQP_PENSION_TYPES_F

Line 354: l_ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%type;

350: l_configuration_information15 VARCHAR2(10) := 'N' ;
351: l_configuration_information16 VARCHAR2(10) := 'N' ;
352: l_configuration_information17 VARCHAR2(10) := 'N' ;
353:
354: l_ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%type;
355: l_er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%type;
356: l_pen_sal_bal_type_id pqp_pension_types_f.pension_salary_balance%type := -1;
357: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;
358: l_row_id rowid;

Line 355: l_er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%type;

351: l_configuration_information16 VARCHAR2(10) := 'N' ;
352: l_configuration_information17 VARCHAR2(10) := 'N' ;
353:
354: l_ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%type;
355: l_er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%type;
356: l_pen_sal_bal_type_id pqp_pension_types_f.pension_salary_balance%type := -1;
357: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;
358: l_row_id rowid;
359: l_request_id Number;

Line 356: l_pen_sal_bal_type_id pqp_pension_types_f.pension_salary_balance%type := -1;

352: l_configuration_information17 VARCHAR2(10) := 'N' ;
353:
354: l_ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%type;
355: l_er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%type;
356: l_pen_sal_bal_type_id pqp_pension_types_f.pension_salary_balance%type := -1;
357: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;
358: l_row_id rowid;
359: l_request_id Number;
360: l_er_request_id Number;

Line 403: from pqp_pension_types_f

399: --
400: cursor csr_pty (c_pension_type_id number
401: ,c_effective_date date) is
402: select ee_contribution_bal_type_id
403: from pqp_pension_types_f
404: where pension_type_id = c_pension_type_id
405: and business_group_id = p_business_group_id
406: and c_effective_date between effective_start_date
407: and effective_end_date;

Line 412: from pqp_pension_types_f

408:
409: cursor csr_pty1 (c_pension_type_id number
410: ,c_effective_date date) is
411: select *
412: from pqp_pension_types_f
413: where pension_type_id = c_pension_type_id
414: and business_group_id = p_business_group_id
415: and c_effective_date between effective_start_date
416: and effective_end_date;

Line 421: from pqp_pension_types_f

417:
418: cursor csr_pty2 (c_pension_type_id number
419: ,c_effective_date date) is
420: select er_contribution_bal_type_id
421: from pqp_pension_types_f
422: where pension_type_id = c_pension_type_id
423: and business_group_id = p_business_group_id
424: and c_effective_date between effective_start_date
425: and effective_end_date;

Line 431: from pqp_pension_types_f

427: -- cursor added to query the pension_sal_bal_id
428: cursor csr_pty3 (c_pension_type_id number
429: ,c_effective_date date) is
430: select pension_salary_balance
431: from pqp_pension_types_f
432: where pension_type_id = c_pension_type_id
433: and business_group_id = p_business_group_id
434: and c_effective_date between effective_start_date
435: and effective_end_date;

Line 437: r_pty_rec pqp_pension_types_f%ROWTYPE;

433: and business_group_id = p_business_group_id
434: and c_effective_date between effective_start_date
435: and effective_end_date;
436:
437: r_pty_rec pqp_pension_types_f%ROWTYPE;
438:
439:
440: cursor csr_get_formula_txt (c_formula_id number) is
441: select formula_text