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

Line 199: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;

195: g_date_paid DATE;
196: g_asg_primary_flag VARCHAR2(1);
197: g_per_agg_flag VARCHAR2(1);
198: g_reset_flag_type VARCHAR2(30);
199: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;
200: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
201: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
202: g_taxable_ptd_id pay_defined_balances.defined_balance_id%TYPE;
203: g_student_loan_ptd_id pay_defined_balances.defined_balance_id%TYPE;

Line 200: g_paye_id pay_defined_balances.defined_balance_id%TYPE;

196: g_asg_primary_flag VARCHAR2(1);
197: g_per_agg_flag VARCHAR2(1);
198: g_reset_flag_type VARCHAR2(30);
199: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;
200: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
201: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
202: g_taxable_ptd_id pay_defined_balances.defined_balance_id%TYPE;
203: g_student_loan_ptd_id pay_defined_balances.defined_balance_id%TYPE;
204: g_paye_ptd_id pay_defined_balances.defined_balance_id%TYPE;

Line 201: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;

197: g_per_agg_flag VARCHAR2(1);
198: g_reset_flag_type VARCHAR2(30);
199: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;
200: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
201: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
202: g_taxable_ptd_id pay_defined_balances.defined_balance_id%TYPE;
203: g_student_loan_ptd_id pay_defined_balances.defined_balance_id%TYPE;
204: g_paye_ptd_id pay_defined_balances.defined_balance_id%TYPE;
205: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;

Line 202: g_taxable_ptd_id pay_defined_balances.defined_balance_id%TYPE;

198: g_reset_flag_type VARCHAR2(30);
199: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;
200: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
201: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
202: g_taxable_ptd_id pay_defined_balances.defined_balance_id%TYPE;
203: g_student_loan_ptd_id pay_defined_balances.defined_balance_id%TYPE;
204: g_paye_ptd_id pay_defined_balances.defined_balance_id%TYPE;
205: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
206: g_smp_id pay_defined_balances.defined_balance_id%TYPE;

Line 203: g_student_loan_ptd_id pay_defined_balances.defined_balance_id%TYPE;

199: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;
200: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
201: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
202: g_taxable_ptd_id pay_defined_balances.defined_balance_id%TYPE;
203: g_student_loan_ptd_id pay_defined_balances.defined_balance_id%TYPE;
204: g_paye_ptd_id pay_defined_balances.defined_balance_id%TYPE;
205: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
206: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
207: g_ospp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

Line 204: g_paye_ptd_id pay_defined_balances.defined_balance_id%TYPE;

200: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
201: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
202: g_taxable_ptd_id pay_defined_balances.defined_balance_id%TYPE;
203: g_student_loan_ptd_id pay_defined_balances.defined_balance_id%TYPE;
204: g_paye_ptd_id pay_defined_balances.defined_balance_id%TYPE;
205: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
206: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
207: g_ospp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
208: g_sap_id pay_defined_balances.defined_balance_id%TYPE;

Line 205: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;

201: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
202: g_taxable_ptd_id pay_defined_balances.defined_balance_id%TYPE;
203: g_student_loan_ptd_id pay_defined_balances.defined_balance_id%TYPE;
204: g_paye_ptd_id pay_defined_balances.defined_balance_id%TYPE;
205: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
206: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
207: g_ospp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
208: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
209: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

Line 206: g_smp_id pay_defined_balances.defined_balance_id%TYPE;

202: g_taxable_ptd_id pay_defined_balances.defined_balance_id%TYPE;
203: g_student_loan_ptd_id pay_defined_balances.defined_balance_id%TYPE;
204: g_paye_ptd_id pay_defined_balances.defined_balance_id%TYPE;
205: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
206: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
207: g_ospp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
208: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
209: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
210: g_final_submission VARCHAR2(100);

Line 207: g_ospp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

203: g_student_loan_ptd_id pay_defined_balances.defined_balance_id%TYPE;
204: g_paye_ptd_id pay_defined_balances.defined_balance_id%TYPE;
205: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
206: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
207: g_ospp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
208: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
209: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
210: g_final_submission VARCHAR2(100);
211: g_free_tax_payments_made VARCHAR2(100);

Line 208: g_sap_id pay_defined_balances.defined_balance_id%TYPE;

204: g_paye_ptd_id pay_defined_balances.defined_balance_id%TYPE;
205: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
206: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
207: g_ospp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
208: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
209: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
210: g_final_submission VARCHAR2(100);
211: g_free_tax_payments_made VARCHAR2(100);
212: g_expenses_benefits_others VARCHAR2(100);

Line 209: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

205: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
206: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
207: g_ospp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
208: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
209: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
210: g_final_submission VARCHAR2(100);
211: g_free_tax_payments_made VARCHAR2(100);
212: g_expenses_benefits_others VARCHAR2(100);
213: g_employed_outside_uk VARCHAR2(100);

Line 4524: select pdb.defined_balance_id from pay_defined_balances pdb,

4520: and e1.assignment_id = p_asg_id
4521: and e1.element_link_id = link1.element_link_id);
4522:
4523: cursor csr_get_taxable_pay(c_balance_name varchar2, c_dim_name varchar2) is
4524: select pdb.defined_balance_id from pay_defined_balances pdb,
4525: pay_balance_dimensions pbd,
4526: pay_balance_types pbt
4527: where pbt.balance_name = c_balance_name
4528: and pbd.database_item_suffix = c_dim_name

Line 5191: select pdb.defined_balance_id from pay_defined_balances pdb,

5187: and e1.element_link_id = link1.element_link_id);
5188:
5189:
5190: cursor csr_get_taxable_pay(c_balance_name varchar2, c_dim_name varchar2) is
5191: select pdb.defined_balance_id from pay_defined_balances pdb,
5192: pay_balance_dimensions pbd,
5193: pay_balance_types pbt
5194: where pbt.balance_name = c_balance_name
5195: and pbd.database_item_suffix = c_dim_name

Line 6287: FROM pay_defined_balances db

6283: -- get the defined balance id for specified balance and dimension
6284: cursor get_defined_balance_id
6285: (p_balance_name VARCHAR2, p_dimension_name VARCHAR2) IS
6286: SELECT defined_balance_id
6287: FROM pay_defined_balances db
6288: , pay_balance_types b
6289: , pay_balance_dimensions d
6290: WHERE b.balance_name = p_balance_name
6291: AND d.dimension_name = p_dimension_name

Line 7342: FROM pay_defined_balances db,

7338: b.balance_type_id balance_type_id,
7339: d.database_item_suffix database_item_suffix,
7340: d.balance_dimension_id balance_dimension_id,
7341: db.defined_balance_id defined_balance_id
7342: FROM pay_defined_balances db,
7343: pay_balance_types b,
7344: pay_balance_dimensions d
7345: WHERE db.balance_type_id = b.balance_type_id
7346: AND db.balance_dimension_id = d.balance_dimension_id

Line 7393: FROM pay_defined_balances db,

7389: b.balance_type_id balance_type_id,
7390: d.database_item_suffix database_item_suffix,
7391: d.balance_dimension_id balance_dimension_id,
7392: db.defined_balance_id defined_balance_id
7393: FROM pay_defined_balances db,
7394: pay_balance_types b,
7395: pay_balance_dimensions d
7396: WHERE db.balance_type_id = b.balance_type_id
7397: AND db.balance_dimension_id = d.balance_dimension_id

Line 7609: pay_defined_balances pdb where

7605: procedure add_other_asg_ni_ytd(c_asg_act_id in number , p_archive_tab in out nocopy act_info_rec) is
7606:
7607: cursor csr_def_bal_id(c_bal_name varchar2, c_dim_name varchar2) is
7608: select pdb.defined_balance_id from pay_balance_types pbt, pay_balance_dimensions pbd,
7609: pay_defined_balances pdb where
7610: pbt.balance_name = c_bal_name
7611: and pbd.database_item_suffix = c_dim_name
7612: and pdb.balance_type_id = pbt.balance_type_id
7613: and pdb.balance_dimension_id = pbd.balance_dimension_id

Line 8618: FROM pay_defined_balances db

8614: -- get the defined balance id for specified balance and dimension
8615: cursor get_defined_balance_id
8616: (p_balance_name VARCHAR2, p_dimension_name VARCHAR2) IS
8617: SELECT defined_balance_id
8618: FROM pay_defined_balances db
8619: , pay_balance_types b
8620: , pay_balance_dimensions d
8621: WHERE b.balance_name = p_balance_name
8622: AND d.dimension_name = p_dimension_name