APPS.PAY_FI_ARCHIVE_PSTA dependencies on PAY_BALANCE_DIMENSIONS

Line 512: l_database_ytd_item_suffix pay_balance_dimensions.database_item_suffix%type;

508: type benefit_type is table of varchar2 (240)
509: index by binary_integer;
510:
511: benefit_type_tab benefit_type;
512: l_database_ytd_item_suffix pay_balance_dimensions.database_item_suffix%type;
513: l_database_ptd_item_suffix pay_balance_dimensions.database_item_suffix%type;
514: l_actid number;
515: l_ytd_value number := 0;
516: l_person_last_period number;

Line 513: l_database_ptd_item_suffix pay_balance_dimensions.database_item_suffix%type;

509: index by binary_integer;
510:
511: benefit_type_tab benefit_type;
512: l_database_ytd_item_suffix pay_balance_dimensions.database_item_suffix%type;
513: l_database_ptd_item_suffix pay_balance_dimensions.database_item_suffix%type;
514: l_actid number;
515: l_ytd_value number := 0;
516: l_person_last_period number;
517:

Line 1279: l_database_item_suffix pay_balance_dimensions.database_item_suffix%type;

1275: l_tax_at_source_base number;
1276: l_deductions_b_tax number;
1277: l_external_expenses number;
1278: l_payroll_archived_flag char (1) := 'N';
1279: l_database_item_suffix pay_balance_dimensions.database_item_suffix%type;
1280: l_tax_amount number;
1281: l_termination_date date;
1282: l_effective_date date;
1283: l_monetary_value number := 0;

Line 1812: from pay_balance_types pbt, pay_balance_dimensions pbd, pay_defined_balances pdb

1808: cursor csr_get_defined_balance_id (
1809: csr_v_balance_name ff_database_items.user_name%type
1810: ) is
1811: select defined_balance_id
1812: from pay_balance_types pbt, pay_balance_dimensions pbd, pay_defined_balances pdb
1813: where pbt.balance_name = csr_v_balance_name
1814: and nvl(pbt.business_group_id,g_business_group_id) = g_business_group_id
1815: and pbt.balance_type_id = pdb.balance_type_id
1816: and pbd.database_item_suffix = p_database_item_suffix --'_PER_YTD'