APPS.PQP_NL_PENSION_TEMPLATE dependencies on PQP_PENSION_TYPES_F

Line 356: l_ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%type;

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

Line 357: l_er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%type;

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

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

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

Line 405: from pqp_pension_types_f

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

Line 414: from pqp_pension_types_f

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

Line 423: from pqp_pension_types_f

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

Line 433: from pqp_pension_types_f

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

Line 439: r_pty_rec pqp_pension_types_f%ROWTYPE;

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