eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_UITE_ARCH_PKG dependencies on PAY_DEFINED_BALANCES

Line 1006: ,pay_defined_balances PDB

1002: SELECT PDB.defined_balance_id
1003: ,PBT.balance_type_id
1004: FROM pay_balance_types PBT
1005: ,pay_balance_dimensions PBD
1006: ,pay_defined_balances PDB
1007: WHERE PBT.balance_name = p_balance_name
1008: AND PBD.database_item_suffix = p_database_item_suffix
1009: AND PBT.balance_type_id = PDB.balance_type_id
1010: AND PBD.balance_dimension_id = PDB.balance_dimension_id;

Line 1084: ln_bpd_balance_id pay_defined_balances.defined_balance_id%TYPE;

1080: ln_base_days NUMBER;
1081: ln_wage_amount_a NUMBER;
1082: ln_wage_amount_b NUMBER;
1083: ln_total_wage NUMBER;
1084: ln_bpd_balance_id pay_defined_balances.defined_balance_id%TYPE;
1085: ln_sal_a_bal_id pay_defined_balances.defined_balance_id%TYPE;
1086: ln_sal_b_bal_id pay_defined_balances.defined_balance_id%TYPE;
1087: ln_sal_a_prev_bal_id pay_defined_balances.defined_balance_id%TYPE;
1088: ln_sal_b_prev_bal_id pay_defined_balances.defined_balance_id%TYPE;

Line 1085: ln_sal_a_bal_id pay_defined_balances.defined_balance_id%TYPE;

1081: ln_wage_amount_a NUMBER;
1082: ln_wage_amount_b NUMBER;
1083: ln_total_wage NUMBER;
1084: ln_bpd_balance_id pay_defined_balances.defined_balance_id%TYPE;
1085: ln_sal_a_bal_id pay_defined_balances.defined_balance_id%TYPE;
1086: ln_sal_b_bal_id pay_defined_balances.defined_balance_id%TYPE;
1087: ln_sal_a_prev_bal_id pay_defined_balances.defined_balance_id%TYPE;
1088: ln_sal_b_prev_bal_id pay_defined_balances.defined_balance_id%TYPE;
1089: ln_bpd_baltyp_id pay_balance_types.balance_type_id%TYPE;

Line 1086: ln_sal_b_bal_id pay_defined_balances.defined_balance_id%TYPE;

1082: ln_wage_amount_b NUMBER;
1083: ln_total_wage NUMBER;
1084: ln_bpd_balance_id pay_defined_balances.defined_balance_id%TYPE;
1085: ln_sal_a_bal_id pay_defined_balances.defined_balance_id%TYPE;
1086: ln_sal_b_bal_id pay_defined_balances.defined_balance_id%TYPE;
1087: ln_sal_a_prev_bal_id pay_defined_balances.defined_balance_id%TYPE;
1088: ln_sal_b_prev_bal_id pay_defined_balances.defined_balance_id%TYPE;
1089: ln_bpd_baltyp_id pay_balance_types.balance_type_id%TYPE;
1090: ln_sal_a_baltyp_id pay_balance_types.balance_type_id%TYPE;

Line 1087: ln_sal_a_prev_bal_id pay_defined_balances.defined_balance_id%TYPE;

1083: ln_total_wage NUMBER;
1084: ln_bpd_balance_id pay_defined_balances.defined_balance_id%TYPE;
1085: ln_sal_a_bal_id pay_defined_balances.defined_balance_id%TYPE;
1086: ln_sal_b_bal_id pay_defined_balances.defined_balance_id%TYPE;
1087: ln_sal_a_prev_bal_id pay_defined_balances.defined_balance_id%TYPE;
1088: ln_sal_b_prev_bal_id pay_defined_balances.defined_balance_id%TYPE;
1089: ln_bpd_baltyp_id pay_balance_types.balance_type_id%TYPE;
1090: ln_sal_a_baltyp_id pay_balance_types.balance_type_id%TYPE;
1091: ln_sal_b_baltyp_id pay_balance_types.balance_type_id%TYPE;

Line 1088: ln_sal_b_prev_bal_id pay_defined_balances.defined_balance_id%TYPE;

1084: ln_bpd_balance_id pay_defined_balances.defined_balance_id%TYPE;
1085: ln_sal_a_bal_id pay_defined_balances.defined_balance_id%TYPE;
1086: ln_sal_b_bal_id pay_defined_balances.defined_balance_id%TYPE;
1087: ln_sal_a_prev_bal_id pay_defined_balances.defined_balance_id%TYPE;
1088: ln_sal_b_prev_bal_id pay_defined_balances.defined_balance_id%TYPE;
1089: ln_bpd_baltyp_id pay_balance_types.balance_type_id%TYPE;
1090: ln_sal_a_baltyp_id pay_balance_types.balance_type_id%TYPE;
1091: ln_sal_b_baltyp_id pay_balance_types.balance_type_id%TYPE;
1092: ln_sal_a_prev_baltyp_id pay_balance_types.balance_type_id%TYPE;

Line 1805: ,pay_defined_balances PDB

1801: IS
1802: SELECT PDB.defined_balance_id
1803: FROM pay_balance_types PBT
1804: ,pay_balance_dimensions PBD
1805: ,pay_defined_balances PDB
1806: WHERE PBT.balance_name = p_balance_name
1807: AND PBD.database_item_suffix = p_database_item_suffix
1808: AND PBT.balance_type_id = PDB.balance_type_id
1809: AND PBD.balance_dimension_id = PDB.balance_dimension_id;

Line 1816: ln_spb_bal_id pay_defined_balances.defined_balance_id%TYPE;

1812: --
1813: ln_action_info_id pay_action_information.action_information_id%TYPE;
1814: ln_obj_version_num pay_action_information.object_version_number%TYPE;
1815: ln_spb_earnings NUMBER;
1816: ln_spb_bal_id pay_defined_balances.defined_balance_id%TYPE;
1817: ln_spb_assact_tbl_cnt NUMBER := 0;
1818: --
1819: lt_spb_assact_tbl t_spb_assact_tbl;
1820: --