DBA Data[Home] [Help]

APPS.PAY_IE_PENSION_TEMPLATE dependencies on PAY_BALANCE_TYPES

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

499: l_ele_new_name t_ele_name;
500: l_main_ele_name t_ele_name;
501: l_retro_ele_name t_ele_name;
502:
503: type t_bal_name is table of pay_balance_types.balance_name%type
504: index by BINARY_INTEGER;
505: l_bal_name t_bal_name;
506: l_bal_new_name t_bal_name;
507:

Line 537: l_balance_name pay_balance_types.balance_name%TYPE;

533: l_row_id rowid;
534: l_request_id Number;
535: l_er_request_id Number;
536: l_dbi_user_name ff_database_items.user_name%TYPE;
537: l_balance_name pay_balance_types.balance_name%TYPE;
538: l_balance_dbi_name ff_database_items.user_name%TYPE;
539:
540: --
541: cursor csr_get_category (c_pen_type_id number,

Line 550: from pay_balance_types

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
549: select balance_type_id
550: from pay_balance_types
551: where balance_name = c_bal_name
552: and legislation_code='IE'
553: and business_group_id is null;
554: