APPS.PAY_SG_IRAS_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 626: pay_defined_balances pdb,

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

Line 1110: pay_defined_balances pdb,

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

Line 1197: pay_defined_balances pdb,

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

Line 1862: c_def_balance_id pay_defined_balances.defined_balance_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 )
1861: is
1862: c_def_balance_id pay_defined_balances.defined_balance_id%type;
1863: c_run_balance_status pay_balance_validation.run_balance_status%type ;
1864:
1865: --
1866: cursor balance_dates_rr

Line 1938: from pay_defined_balances pdb,

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,
1940: pay_balance_dimensions pbd
1941: where pbt.balance_name = c_balance_name
1942: and pbd.dimension_name = '_ASG_LE_RUN'

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

1946: and pbt.legislation_code = 'SG'
1947: and pbd.legislation_code = 'SG';
1948:
1949: --
1950: cursor get_balance_status(c_def_balance_id pay_defined_balances.defined_balance_id%type,
1951: c_business_group_id hr_organization_units.business_group_id%type )
1952: is
1953: select run_balance_status
1954: from pay_balance_validation