APPS.PAY_SG_IRAS_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 619: pay_defined_balances pdb,

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'
623: and pbt.legislation_code = 'SG'

Line 1099: pay_defined_balances pdb,

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'
1103: and pbt.legislation_code = 'SG'

Line 1186: pay_defined_balances pdb,

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'
1190: and pbt.legislation_code = 'SG'

Line 1851: c_def_balance_id pay_defined_balances.defined_balance_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 )
1850: is
1851: c_def_balance_id pay_defined_balances.defined_balance_id%type;
1852: c_run_balance_status pay_balance_validation.run_balance_status%type ;
1853:
1854: --
1855: cursor balance_dates_rr

Line 1927: from pay_defined_balances pdb,

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,
1929: pay_balance_dimensions pbd
1930: where pbt.balance_name = c_balance_name
1931: and pbd.dimension_name = '_ASG_LE_RUN'

Line 1939: cursor get_balance_status(c_def_balance_id pay_defined_balances.defined_balance_id%type,

1935: and pbt.legislation_code = 'SG'
1936: and pbd.legislation_code = 'SG';
1937:
1938: --
1939: cursor get_balance_status(c_def_balance_id pay_defined_balances.defined_balance_id%type,
1940: c_business_group_id hr_organization_units.business_group_id%type )
1941: is
1942: select run_balance_status
1943: from pay_balance_validation