DBA Data[Home] [Help]

APPS.PAY_IE_PENSION_TEMPLATE dependencies on PAY_BALANCE_TYPES

Line 512: type t_bal_name is table of pay_balance_types.balance_name%type

508: l_ele_new_name t_ele_name;
509: l_main_ele_name t_ele_name;
510: l_retro_ele_name t_ele_name;
511:
512: type t_bal_name is table of pay_balance_types.balance_name%type
513: index by BINARY_INTEGER;
514: l_bal_name t_bal_name;
515: l_bal_new_name t_bal_name;
516:

Line 546: l_balance_name pay_balance_types.balance_name%TYPE;

542: l_row_id rowid;
543: l_request_id Number;
544: l_er_request_id Number;
545: l_dbi_user_name ff_database_items.user_name%TYPE;
546: l_balance_name pay_balance_types.balance_name%TYPE;
547: l_balance_dbi_name ff_database_items.user_name%TYPE;
548:
549: --
550: cursor csr_get_category (c_pen_type_id number,

Line 559: from pay_balance_types

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
558: select balance_type_id
559: from pay_balance_types
560: where balance_name = c_bal_name
561: and legislation_code='IE'
562: and business_group_id is null;
563: