eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_BALANCE_PKG dependencies on PAY_LATEST_BALANCES

Line 298: g_con_tax_unit_id pay_latest_balances.tax_unit_id%type;

294: -- set by get_oracle_db_version
295: --
296: -- Setup the internal context settings
297: --
298: g_con_tax_unit_id pay_latest_balances.tax_unit_id%type;
299: g_con_jurisdiction_code pay_latest_balances.jurisdiction_code%type;
300: g_con_original_entry_id pay_latest_balances.original_entry_id%type;
301: g_con_source_id pay_latest_balances.source_id%type;
302: g_con_source_text pay_latest_balances.source_text%type;

Line 299: g_con_jurisdiction_code pay_latest_balances.jurisdiction_code%type;

295: --
296: -- Setup the internal context settings
297: --
298: g_con_tax_unit_id pay_latest_balances.tax_unit_id%type;
299: g_con_jurisdiction_code pay_latest_balances.jurisdiction_code%type;
300: g_con_original_entry_id pay_latest_balances.original_entry_id%type;
301: g_con_source_id pay_latest_balances.source_id%type;
302: g_con_source_text pay_latest_balances.source_text%type;
303: g_con_source_text2 pay_latest_balances.source_text2%type;

Line 300: g_con_original_entry_id pay_latest_balances.original_entry_id%type;

296: -- Setup the internal context settings
297: --
298: g_con_tax_unit_id pay_latest_balances.tax_unit_id%type;
299: g_con_jurisdiction_code pay_latest_balances.jurisdiction_code%type;
300: g_con_original_entry_id pay_latest_balances.original_entry_id%type;
301: g_con_source_id pay_latest_balances.source_id%type;
302: g_con_source_text pay_latest_balances.source_text%type;
303: g_con_source_text2 pay_latest_balances.source_text2%type;
304: g_con_source_number pay_latest_balances.source_number%type;

Line 301: g_con_source_id pay_latest_balances.source_id%type;

297: --
298: g_con_tax_unit_id pay_latest_balances.tax_unit_id%type;
299: g_con_jurisdiction_code pay_latest_balances.jurisdiction_code%type;
300: g_con_original_entry_id pay_latest_balances.original_entry_id%type;
301: g_con_source_id pay_latest_balances.source_id%type;
302: g_con_source_text pay_latest_balances.source_text%type;
303: g_con_source_text2 pay_latest_balances.source_text2%type;
304: g_con_source_number pay_latest_balances.source_number%type;
305: g_con_tax_group pay_latest_balances.tax_group%type;

Line 302: g_con_source_text pay_latest_balances.source_text%type;

298: g_con_tax_unit_id pay_latest_balances.tax_unit_id%type;
299: g_con_jurisdiction_code pay_latest_balances.jurisdiction_code%type;
300: g_con_original_entry_id pay_latest_balances.original_entry_id%type;
301: g_con_source_id pay_latest_balances.source_id%type;
302: g_con_source_text pay_latest_balances.source_text%type;
303: g_con_source_text2 pay_latest_balances.source_text2%type;
304: g_con_source_number pay_latest_balances.source_number%type;
305: g_con_tax_group pay_latest_balances.tax_group%type;
306: g_con_payroll_id pay_latest_balances.payroll_id%type;

Line 303: g_con_source_text2 pay_latest_balances.source_text2%type;

299: g_con_jurisdiction_code pay_latest_balances.jurisdiction_code%type;
300: g_con_original_entry_id pay_latest_balances.original_entry_id%type;
301: g_con_source_id pay_latest_balances.source_id%type;
302: g_con_source_text pay_latest_balances.source_text%type;
303: g_con_source_text2 pay_latest_balances.source_text2%type;
304: g_con_source_number pay_latest_balances.source_number%type;
305: g_con_tax_group pay_latest_balances.tax_group%type;
306: g_con_payroll_id pay_latest_balances.payroll_id%type;
307: g_con_local_unit_id pay_latest_balances.local_unit_id%type;

Line 304: g_con_source_number pay_latest_balances.source_number%type;

300: g_con_original_entry_id pay_latest_balances.original_entry_id%type;
301: g_con_source_id pay_latest_balances.source_id%type;
302: g_con_source_text pay_latest_balances.source_text%type;
303: g_con_source_text2 pay_latest_balances.source_text2%type;
304: g_con_source_number pay_latest_balances.source_number%type;
305: g_con_tax_group pay_latest_balances.tax_group%type;
306: g_con_payroll_id pay_latest_balances.payroll_id%type;
307: g_con_local_unit_id pay_latest_balances.local_unit_id%type;
308: g_con_organization_id pay_latest_balances.organization_id%type;

Line 305: g_con_tax_group pay_latest_balances.tax_group%type;

301: g_con_source_id pay_latest_balances.source_id%type;
302: g_con_source_text pay_latest_balances.source_text%type;
303: g_con_source_text2 pay_latest_balances.source_text2%type;
304: g_con_source_number pay_latest_balances.source_number%type;
305: g_con_tax_group pay_latest_balances.tax_group%type;
306: g_con_payroll_id pay_latest_balances.payroll_id%type;
307: g_con_local_unit_id pay_latest_balances.local_unit_id%type;
308: g_con_organization_id pay_latest_balances.organization_id%type;
309: g_con_source_number2 pay_latest_balances.source_number2%type;

Line 306: g_con_payroll_id pay_latest_balances.payroll_id%type;

302: g_con_source_text pay_latest_balances.source_text%type;
303: g_con_source_text2 pay_latest_balances.source_text2%type;
304: g_con_source_number pay_latest_balances.source_number%type;
305: g_con_tax_group pay_latest_balances.tax_group%type;
306: g_con_payroll_id pay_latest_balances.payroll_id%type;
307: g_con_local_unit_id pay_latest_balances.local_unit_id%type;
308: g_con_organization_id pay_latest_balances.organization_id%type;
309: g_con_source_number2 pay_latest_balances.source_number2%type;
310: --

Line 307: g_con_local_unit_id pay_latest_balances.local_unit_id%type;

303: g_con_source_text2 pay_latest_balances.source_text2%type;
304: g_con_source_number pay_latest_balances.source_number%type;
305: g_con_tax_group pay_latest_balances.tax_group%type;
306: g_con_payroll_id pay_latest_balances.payroll_id%type;
307: g_con_local_unit_id pay_latest_balances.local_unit_id%type;
308: g_con_organization_id pay_latest_balances.organization_id%type;
309: g_con_source_number2 pay_latest_balances.source_number2%type;
310: --
311: -- Copy of Hr_General2.get_oracle_db_version to avoid a very nasty patching

Line 308: g_con_organization_id pay_latest_balances.organization_id%type;

304: g_con_source_number pay_latest_balances.source_number%type;
305: g_con_tax_group pay_latest_balances.tax_group%type;
306: g_con_payroll_id pay_latest_balances.payroll_id%type;
307: g_con_local_unit_id pay_latest_balances.local_unit_id%type;
308: g_con_organization_id pay_latest_balances.organization_id%type;
309: g_con_source_number2 pay_latest_balances.source_number2%type;
310: --
311: -- Copy of Hr_General2.get_oracle_db_version to avoid a very nasty patching
312: -- issue in the c-code chain.

Line 309: g_con_source_number2 pay_latest_balances.source_number2%type;

305: g_con_tax_group pay_latest_balances.tax_group%type;
306: g_con_payroll_id pay_latest_balances.payroll_id%type;
307: g_con_local_unit_id pay_latest_balances.local_unit_id%type;
308: g_con_organization_id pay_latest_balances.organization_id%type;
309: g_con_source_number2 pay_latest_balances.source_number2%type;
310: --
311: -- Copy of Hr_General2.get_oracle_db_version to avoid a very nasty patching
312: -- issue in the c-code chain.
313: -- Bug 2865665.

Line 3993: from pay_latest_balances plb

3989: plb.payroll_id,
3990: plb.local_unit_id,
3991: plb.organization_id,
3992: plb.source_number2
3993: from pay_latest_balances plb
3994: , per_all_assignments_f ASSIGN
3995: , pay_assignment_actions ACT
3996: , pay_payroll_actions PACT
3997: , pay_assignment_actions OWN_ACT

Line 4048: l_balance_value pay_latest_balances.value%type;

4044: and nvl(plb.source_number2, nvl(g_con_source_number2, -1))
4045: = nvl(g_con_source_number2, -1)
4046: order by plb.latest_balance_id;
4047: --
4048: l_balance_value pay_latest_balances.value%type;
4049: l_bal_owner_asg_action pay_latest_balances.assignment_action_id%type;
4050: --
4051: l_num_of_runs number;
4052: l_bal_con_str varchar2(500); -- Balance context string

Line 4049: l_bal_owner_asg_action pay_latest_balances.assignment_action_id%type;

4045: = nvl(g_con_source_number2, -1)
4046: order by plb.latest_balance_id;
4047: --
4048: l_balance_value pay_latest_balances.value%type;
4049: l_bal_owner_asg_action pay_latest_balances.assignment_action_id%type;
4050: --
4051: l_num_of_runs number;
4052: l_bal_con_str varchar2(500); -- Balance context string
4053: l_balance_expired number;