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

Line 74: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;

70: g_date_paid DATE;
71: g_asg_primary_flag VARCHAR2(1);
72: g_per_agg_flag VARCHAR2(1);
73: g_reset_flag_type VARCHAR2(30);
74: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;
75: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
76: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
77: g_taxable_ptd_id pay_defined_balances.defined_balance_id%TYPE;
78: g_student_loan_ptd_id pay_defined_balances.defined_balance_id%TYPE;

Line 75: g_paye_id pay_defined_balances.defined_balance_id%TYPE;

71: g_asg_primary_flag VARCHAR2(1);
72: g_per_agg_flag VARCHAR2(1);
73: g_reset_flag_type VARCHAR2(30);
74: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;
75: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
76: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
77: g_taxable_ptd_id pay_defined_balances.defined_balance_id%TYPE;
78: g_student_loan_ptd_id pay_defined_balances.defined_balance_id%TYPE;
79: g_paye_ptd_id pay_defined_balances.defined_balance_id%TYPE;

Line 76: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;

72: g_per_agg_flag VARCHAR2(1);
73: g_reset_flag_type VARCHAR2(30);
74: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;
75: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
76: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
77: g_taxable_ptd_id pay_defined_balances.defined_balance_id%TYPE;
78: g_student_loan_ptd_id pay_defined_balances.defined_balance_id%TYPE;
79: g_paye_ptd_id pay_defined_balances.defined_balance_id%TYPE;
80: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;

Line 77: g_taxable_ptd_id pay_defined_balances.defined_balance_id%TYPE;

73: g_reset_flag_type VARCHAR2(30);
74: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;
75: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
76: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
77: g_taxable_ptd_id pay_defined_balances.defined_balance_id%TYPE;
78: g_student_loan_ptd_id pay_defined_balances.defined_balance_id%TYPE;
79: g_paye_ptd_id pay_defined_balances.defined_balance_id%TYPE;
80: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
81: g_smp_id pay_defined_balances.defined_balance_id%TYPE;

Line 78: g_student_loan_ptd_id pay_defined_balances.defined_balance_id%TYPE;

74: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;
75: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
76: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
77: g_taxable_ptd_id pay_defined_balances.defined_balance_id%TYPE;
78: g_student_loan_ptd_id pay_defined_balances.defined_balance_id%TYPE;
79: g_paye_ptd_id pay_defined_balances.defined_balance_id%TYPE;
80: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
81: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
82: g_ospp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

Line 79: g_paye_ptd_id pay_defined_balances.defined_balance_id%TYPE;

75: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
76: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
77: g_taxable_ptd_id pay_defined_balances.defined_balance_id%TYPE;
78: g_student_loan_ptd_id pay_defined_balances.defined_balance_id%TYPE;
79: g_paye_ptd_id pay_defined_balances.defined_balance_id%TYPE;
80: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
81: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
82: g_ospp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
83: g_sap_id pay_defined_balances.defined_balance_id%TYPE;

Line 80: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;

76: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
77: g_taxable_ptd_id pay_defined_balances.defined_balance_id%TYPE;
78: g_student_loan_ptd_id pay_defined_balances.defined_balance_id%TYPE;
79: g_paye_ptd_id pay_defined_balances.defined_balance_id%TYPE;
80: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
81: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
82: g_ospp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
83: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
84: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

Line 81: g_smp_id pay_defined_balances.defined_balance_id%TYPE;

77: g_taxable_ptd_id pay_defined_balances.defined_balance_id%TYPE;
78: g_student_loan_ptd_id pay_defined_balances.defined_balance_id%TYPE;
79: g_paye_ptd_id pay_defined_balances.defined_balance_id%TYPE;
80: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
81: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
82: g_ospp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
83: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
84: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
85: g_final_submission VARCHAR2(100);

Line 82: g_ospp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

78: g_student_loan_ptd_id pay_defined_balances.defined_balance_id%TYPE;
79: g_paye_ptd_id pay_defined_balances.defined_balance_id%TYPE;
80: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
81: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
82: g_ospp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
83: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
84: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
85: g_final_submission VARCHAR2(100);
86: g_free_tax_payments_made VARCHAR2(100);

Line 83: g_sap_id pay_defined_balances.defined_balance_id%TYPE;

79: g_paye_ptd_id pay_defined_balances.defined_balance_id%TYPE;
80: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
81: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
82: g_ospp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
83: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
84: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
85: g_final_submission VARCHAR2(100);
86: g_free_tax_payments_made VARCHAR2(100);
87: g_expenses_benefits_others VARCHAR2(100);

Line 84: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

80: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
81: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
82: g_ospp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
83: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
84: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
85: g_final_submission VARCHAR2(100);
86: g_free_tax_payments_made VARCHAR2(100);
87: g_expenses_benefits_others VARCHAR2(100);
88: g_employed_outside_uk VARCHAR2(100);

Line 1557: FROM pay_defined_balances db

1553: -- get the defined balance id for specified balance and dimension
1554: cursor get_defined_balance_id
1555: (p_balance_name VARCHAR2, p_dimension_name VARCHAR2) IS
1556: SELECT defined_balance_id
1557: FROM pay_defined_balances db
1558: , pay_balance_types b
1559: , pay_balance_dimensions d
1560: WHERE b.balance_name = p_balance_name
1561: AND d.dimension_name = p_dimension_name

Line 4274: FROM pay_defined_balances db,

4270:
4271: CURSOR get_defined_balance_id_ni(c_ni_cat VARCHAR2, c_dim VARCHAR2)
4272: IS
4273: SELECT db.defined_balance_id defined_balance_id
4274: FROM pay_defined_balances db,
4275: pay_balance_types b,
4276: pay_balance_dimensions d
4277: WHERE db.balance_type_id = b.balance_type_id
4278: AND db.balance_dimension_id = d.balance_dimension_id

Line 4288: FROM pay_defined_balances db,

4284:
4285: CURSOR get_def_bal_id_ni_total_emplyr(c_dim VARCHAR2)
4286: IS
4287: SELECT db.defined_balance_id defined_balance_id
4288: FROM pay_defined_balances db,
4289: pay_balance_types b,
4290: pay_balance_dimensions d
4291: WHERE db.balance_type_id = b.balance_type_id
4292: AND db.balance_dimension_id = d.balance_dimension_id

Line 5122: select pdb.defined_balance_id from pay_defined_balances pdb,

5118: and e1.assignment_id = p_asg_id
5119: and e1.element_link_id = link1.element_link_id);
5120:
5121: cursor csr_get_taxable_pay(c_balance_name varchar2, c_dim_name varchar2) is
5122: select pdb.defined_balance_id from pay_defined_balances pdb,
5123: pay_balance_dimensions pbd,
5124: pay_balance_types pbt
5125: where pbt.balance_name = c_balance_name
5126: and pbd.database_item_suffix = c_dim_name

Line 5805: select pdb.defined_balance_id from pay_defined_balances pdb,

5801: and e1.element_link_id = link1.element_link_id);
5802:
5803:
5804: cursor csr_get_taxable_pay(c_balance_name varchar2, c_dim_name varchar2) is
5805: select pdb.defined_balance_id from pay_defined_balances pdb,
5806: pay_balance_dimensions pbd,
5807: pay_balance_types pbt
5808: where pbt.balance_name = c_balance_name
5809: and pbd.database_item_suffix = c_dim_name

Line 6956: FROM pay_defined_balances db

6952: -- get the defined balance id for specified balance and dimension
6953: cursor get_defined_balance_id
6954: (p_balance_name VARCHAR2, p_dimension_name VARCHAR2) IS
6955: SELECT defined_balance_id
6956: FROM pay_defined_balances db
6957: , pay_balance_types b
6958: , pay_balance_dimensions d
6959: WHERE b.balance_name = p_balance_name
6960: AND d.dimension_name = p_dimension_name

Line 7971: FROM pay_defined_balances db,

7967: b.balance_type_id balance_type_id,
7968: d.database_item_suffix database_item_suffix,
7969: d.balance_dimension_id balance_dimension_id,
7970: db.defined_balance_id defined_balance_id
7971: FROM pay_defined_balances db,
7972: pay_balance_types b,
7973: pay_balance_dimensions d
7974: WHERE db.balance_type_id = b.balance_type_id
7975: AND db.balance_dimension_id = d.balance_dimension_id

Line 8022: FROM pay_defined_balances db,

8018: b.balance_type_id balance_type_id,
8019: d.database_item_suffix database_item_suffix,
8020: d.balance_dimension_id balance_dimension_id,
8021: db.defined_balance_id defined_balance_id
8022: FROM pay_defined_balances db,
8023: pay_balance_types b,
8024: pay_balance_dimensions d
8025: WHERE db.balance_type_id = b.balance_type_id
8026: AND db.balance_dimension_id = d.balance_dimension_id

Line 8238: pay_defined_balances pdb where

8234: procedure add_other_asg_ni_ytd(c_asg_act_id in number , p_archive_tab in out nocopy act_info_rec) is
8235:
8236: cursor csr_def_bal_id(c_bal_name varchar2, c_dim_name varchar2) is
8237: select pdb.defined_balance_id from pay_balance_types pbt, pay_balance_dimensions pbd,
8238: pay_defined_balances pdb where
8239: pbt.balance_name = c_bal_name
8240: and pbd.database_item_suffix = c_dim_name
8241: and pdb.balance_type_id = pbt.balance_type_id
8242: and pdb.balance_dimension_id = pbd.balance_dimension_id

Line 9254: FROM pay_defined_balances db

9250: -- get the defined balance id for specified balance and dimension
9251: cursor get_defined_balance_id
9252: (p_balance_name VARCHAR2, p_dimension_name VARCHAR2) IS
9253: SELECT defined_balance_id
9254: FROM pay_defined_balances db
9255: , pay_balance_types b
9256: , pay_balance_dimensions d
9257: WHERE b.balance_name = p_balance_name
9258: AND d.dimension_name = p_dimension_name