[Home] [Help]
621: cursor ytd_A8A_balances is
622: select fue.user_entity_id,
623: pdb.defined_balance_id def_bal_id
624: from ff_user_entities fue,
625: pay_balance_types pbt,
626: pay_defined_balances pdb,
627: pay_balance_dimensions pbd
628: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_YTD'
629: and fue.legislation_code = 'SG'
1105: cursor ytd_balances is
1106: select fue.user_entity_id,
1107: pdb.defined_balance_id def_bal_id
1108: from ff_user_entities fue,
1109: pay_balance_types pbt,
1110: pay_defined_balances pdb,
1111: pay_balance_dimensions pbd
1112: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_YTD'
1113: and fue.legislation_code = 'SG'
1192: is
1193: select fue.user_entity_id,
1194: pdb.defined_balance_id def_bal_id
1195: from ff_user_entities fue,
1196: pay_balance_types pbt,
1197: pay_defined_balances pdb,
1198: pay_balance_dimensions pbd
1199: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_MONTH'
1200: and fue.legislation_code = 'SG'
1852: -------------------------------------------------------------------------------------------
1853: --
1854: procedure get_balance_dates ( p_asg_action_id in pay_assignment_actions.assignment_action_id%type,
1855: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type,
1856: p_balance_name in pay_balance_types.balance_name%type,
1857: p_business_group_id in hr_organization_units.business_group_id%type,
1858: p_date_from out nocopy ff_archive_items.value%type,
1859: p_date_to out nocopy ff_archive_items.value%type,
1860: p_no_of_times out nocopy number )
1869: fnd_date.date_to_canonical(max(pact.date_earned)) date_to,
1870: sum(decode(pact.action_type,'V',-1,1)) no_of_times
1871: from pay_run_result_values target,
1872: pay_balance_feeds_f feed,
1873: pay_balance_types pbt,
1874: pay_run_results rr,
1875: pay_assignment_actions assact,
1876: pay_assignment_actions bal_assact,
1877: pay_payroll_actions pact,
1931:
1932: ------
1933: -- 3956870 Included get_balance_id, get_balance_status cursors to fetch balance id and status details.
1934: ------
1935: cursor get_balance_id(c_balance_name pay_balance_types.balance_name%type)
1936: is
1937: select pdb.defined_balance_id
1938: from pay_defined_balances pdb,
1939: pay_balance_types pbt,
1935: cursor get_balance_id(c_balance_name pay_balance_types.balance_name%type)
1936: is
1937: select pdb.defined_balance_id
1938: from pay_defined_balances pdb,
1939: pay_balance_types pbt,
1940: pay_balance_dimensions pbd
1941: where pbt.balance_name = c_balance_name
1942: and pbd.dimension_name = '_ASG_LE_RUN'
1943: and pbt.balance_type_id = pdb.balance_type_id