[Home] [Help]
614: cursor ytd_A8A_balances is
615: select fue.user_entity_id,
616: pdb.defined_balance_id def_bal_id
617: from ff_user_entities fue,
618: pay_balance_types pbt,
619: pay_defined_balances pdb,
620: pay_balance_dimensions pbd
621: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_YTD'
622: and fue.legislation_code = 'SG'
1094: cursor ytd_balances is
1095: select fue.user_entity_id,
1096: pdb.defined_balance_id def_bal_id
1097: from ff_user_entities fue,
1098: pay_balance_types pbt,
1099: pay_defined_balances pdb,
1100: pay_balance_dimensions pbd
1101: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_YTD'
1102: and fue.legislation_code = 'SG'
1181: is
1182: select fue.user_entity_id,
1183: pdb.defined_balance_id def_bal_id
1184: from ff_user_entities fue,
1185: pay_balance_types pbt,
1186: pay_defined_balances pdb,
1187: pay_balance_dimensions pbd
1188: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_MONTH'
1189: and fue.legislation_code = 'SG'
1841: -------------------------------------------------------------------------------------------
1842: --
1843: procedure get_balance_dates ( p_asg_action_id in pay_assignment_actions.assignment_action_id%type,
1844: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type,
1845: p_balance_name in pay_balance_types.balance_name%type,
1846: p_business_group_id in hr_organization_units.business_group_id%type,
1847: p_date_from out nocopy ff_archive_items.value%type,
1848: p_date_to out nocopy ff_archive_items.value%type,
1849: p_no_of_times out nocopy number )
1858: fnd_date.date_to_canonical(max(pact.date_earned)) date_to,
1859: sum(decode(pact.action_type,'V',-1,1)) no_of_times
1860: from pay_run_result_values target,
1861: pay_balance_feeds_f feed,
1862: pay_balance_types pbt,
1863: pay_run_results rr,
1864: pay_assignment_actions assact,
1865: pay_assignment_actions bal_assact,
1866: pay_payroll_actions pact,
1920:
1921: ------
1922: -- 3956870 Included get_balance_id, get_balance_status cursors to fetch balance id and status details.
1923: ------
1924: cursor get_balance_id(c_balance_name pay_balance_types.balance_name%type)
1925: is
1926: select pdb.defined_balance_id
1927: from pay_defined_balances pdb,
1928: pay_balance_types pbt,
1924: cursor get_balance_id(c_balance_name pay_balance_types.balance_name%type)
1925: is
1926: select pdb.defined_balance_id
1927: from pay_defined_balances pdb,
1928: pay_balance_types pbt,
1929: pay_balance_dimensions pbd
1930: where pbt.balance_name = c_balance_name
1931: and pbd.dimension_name = '_ASG_LE_RUN'
1932: and pbt.balance_type_id = pdb.balance_type_id