[Home] [Help]
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
1562: AND db.balance_type_id = b.balance_type_id
1563: AND db.balance_dimension_id = d.balance_dimension_id
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
4279: AND d.database_item_suffix = c_dim
4280: AND b.balance_name = 'NI '
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
4293: AND d.database_item_suffix = c_dim
4294: AND b.balance_name = 'NI Employer'
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
5127: and pbt.balance_type_id= pdb.balance_type_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
5810: and pbt.balance_type_id= pdb.balance_type_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
6961: AND db.balance_type_id = b.balance_type_id
6962: AND db.balance_dimension_id = d.balance_dimension_id
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
7976: AND ((d.database_item_suffix = '_ASG_TD_YTD'
7977: AND b.balance_name IN ('Taxable Pay','PAYE','Student Loan','SSP Total',
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
8027: AND ((d.database_item_suffix = '_PER_TD_YTD'
8028: AND b.balance_name IN ('Taxable Pay','PAYE','Student Loan','SSP Total','SMP Total',
8233: --
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
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
9259: AND db.balance_type_id = b.balance_type_id
9260: AND db.balance_dimension_id = d.balance_dimension_id