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_US_PAYSLIP_SIMULATION_MAIN dependencies on PAY_DEFINED_BALANCES

Line 986: FROM pay_defined_balances pdb,

982: cp_balance_type_id VARCHAR2,
983: cp_balance_dimension VARCHAR2 )
984: IS
985: SELECT pdb.defined_balance_id
986: FROM pay_defined_balances pdb,
987: pay_balance_dimensions pbd,
988: pay_balance_types pbt
989: WHERE pbt.balance_name = NVL(cp_balance_name,pbt.balance_name)
990: AND pbt.balance_type_id = NVL(cp_balance_type_id,pbt.balance_type_id)

Line 1107: ln_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

1103: IS
1104:
1105: lv_procedure_name VARCHAR2(100) := '.gross_earnings';
1106:
1107: ln_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1108: ln_gross_earnings NUMBER := 0;
1109: lv_balance_name pay_balance_types.balance_name%TYPE := 'Gross Earnings';
1110: lv_dim_dbi_suffix pay_balance_dimensions.database_item_suffix%TYPE;
1111:

Line 1812: ln_ytd_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

1808: AND petei.eei_information18 IS NOT NULL;
1809:
1810: lv_procedure_name VARCHAR2(100) := '.populate_elements';
1811:
1812: ln_ytd_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1813: ln_run_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1814: ln_ptd_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1815: ln_ytd_hours_balance_id pay_defined_balances.defined_balance_id%TYPE;
1816: ln_run_hours_balance_id pay_defined_balances.defined_balance_id%TYPE;

Line 1813: ln_run_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

1809:
1810: lv_procedure_name VARCHAR2(100) := '.populate_elements';
1811:
1812: ln_ytd_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1813: ln_run_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1814: ln_ptd_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1815: ln_ytd_hours_balance_id pay_defined_balances.defined_balance_id%TYPE;
1816: ln_run_hours_balance_id pay_defined_balances.defined_balance_id%TYPE;
1817: ln_ptd_hours_balance_id pay_defined_balances.defined_balance_id%TYPE;

Line 1814: ln_ptd_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

1810: lv_procedure_name VARCHAR2(100) := '.populate_elements';
1811:
1812: ln_ytd_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1813: ln_run_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1814: ln_ptd_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1815: ln_ytd_hours_balance_id pay_defined_balances.defined_balance_id%TYPE;
1816: ln_run_hours_balance_id pay_defined_balances.defined_balance_id%TYPE;
1817: ln_ptd_hours_balance_id pay_defined_balances.defined_balance_id%TYPE;
1818:

Line 1815: ln_ytd_hours_balance_id pay_defined_balances.defined_balance_id%TYPE;

1811:
1812: ln_ytd_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1813: ln_run_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1814: ln_ptd_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1815: ln_ytd_hours_balance_id pay_defined_balances.defined_balance_id%TYPE;
1816: ln_run_hours_balance_id pay_defined_balances.defined_balance_id%TYPE;
1817: ln_ptd_hours_balance_id pay_defined_balances.defined_balance_id%TYPE;
1818:
1819: lv_rate_exists VARCHAR2(1) := 'N';

Line 1816: ln_run_hours_balance_id pay_defined_balances.defined_balance_id%TYPE;

1812: ln_ytd_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1813: ln_run_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1814: ln_ptd_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1815: ln_ytd_hours_balance_id pay_defined_balances.defined_balance_id%TYPE;
1816: ln_run_hours_balance_id pay_defined_balances.defined_balance_id%TYPE;
1817: ln_ptd_hours_balance_id pay_defined_balances.defined_balance_id%TYPE;
1818:
1819: lv_rate_exists VARCHAR2(1) := 'N';
1820:

Line 1817: ln_ptd_hours_balance_id pay_defined_balances.defined_balance_id%TYPE;

1813: ln_run_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1814: ln_ptd_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1815: ln_ytd_hours_balance_id pay_defined_balances.defined_balance_id%TYPE;
1816: ln_run_hours_balance_id pay_defined_balances.defined_balance_id%TYPE;
1817: ln_ptd_hours_balance_id pay_defined_balances.defined_balance_id%TYPE;
1818:
1819: lv_rate_exists VARCHAR2(1) := 'N';
1820:
1821: ln_rate NUMBER(15,5);

Line 2399: ,pay_defined_balances pdb

2395: FROM pay_assignment_actions paa
2396: ,pay_element_classifications pec
2397: ,pay_element_types_f pet
2398: ,pay_balance_types pbt
2399: ,pay_defined_balances pdb
2400: ,pay_run_balances prb
2401: ,pay_element_types_f_tl petl
2402: WHERE paa.assignment_id = cp_assignment_id
2403: AND paa.source_action_id = cp_source_action_id