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 347: g_con_tax_unit_id pay_latest_balances.tax_unit_id%type;

343: g_parm_ximm varchar2(10) := 'N'; -- future pap for execute immediate on dynamic sql calls
344: --
345: -- Setup the internal context settings
346: --
347: g_con_tax_unit_id pay_latest_balances.tax_unit_id%type;
348: g_con_jurisdiction_code pay_latest_balances.jurisdiction_code%type;
349: g_con_original_entry_id pay_latest_balances.original_entry_id%type;
350: g_con_source_id pay_latest_balances.source_id%type;
351: g_con_source_text pay_latest_balances.source_text%type;

Line 348: g_con_jurisdiction_code pay_latest_balances.jurisdiction_code%type;

344: --
345: -- Setup the internal context settings
346: --
347: g_con_tax_unit_id pay_latest_balances.tax_unit_id%type;
348: g_con_jurisdiction_code pay_latest_balances.jurisdiction_code%type;
349: g_con_original_entry_id pay_latest_balances.original_entry_id%type;
350: g_con_source_id pay_latest_balances.source_id%type;
351: g_con_source_text pay_latest_balances.source_text%type;
352: g_con_source_text2 pay_latest_balances.source_text2%type;

Line 349: g_con_original_entry_id pay_latest_balances.original_entry_id%type;

345: -- Setup the internal context settings
346: --
347: g_con_tax_unit_id pay_latest_balances.tax_unit_id%type;
348: g_con_jurisdiction_code pay_latest_balances.jurisdiction_code%type;
349: g_con_original_entry_id pay_latest_balances.original_entry_id%type;
350: g_con_source_id pay_latest_balances.source_id%type;
351: g_con_source_text pay_latest_balances.source_text%type;
352: g_con_source_text2 pay_latest_balances.source_text2%type;
353: g_con_source_number pay_latest_balances.source_number%type;

Line 350: g_con_source_id pay_latest_balances.source_id%type;

346: --
347: g_con_tax_unit_id pay_latest_balances.tax_unit_id%type;
348: g_con_jurisdiction_code pay_latest_balances.jurisdiction_code%type;
349: g_con_original_entry_id pay_latest_balances.original_entry_id%type;
350: g_con_source_id pay_latest_balances.source_id%type;
351: g_con_source_text pay_latest_balances.source_text%type;
352: g_con_source_text2 pay_latest_balances.source_text2%type;
353: g_con_source_number pay_latest_balances.source_number%type;
354: g_con_tax_group pay_latest_balances.tax_group%type;

Line 351: g_con_source_text pay_latest_balances.source_text%type;

347: g_con_tax_unit_id pay_latest_balances.tax_unit_id%type;
348: g_con_jurisdiction_code pay_latest_balances.jurisdiction_code%type;
349: g_con_original_entry_id pay_latest_balances.original_entry_id%type;
350: g_con_source_id pay_latest_balances.source_id%type;
351: g_con_source_text pay_latest_balances.source_text%type;
352: g_con_source_text2 pay_latest_balances.source_text2%type;
353: g_con_source_number pay_latest_balances.source_number%type;
354: g_con_tax_group pay_latest_balances.tax_group%type;
355: g_con_payroll_id pay_latest_balances.payroll_id%type;

Line 352: g_con_source_text2 pay_latest_balances.source_text2%type;

348: g_con_jurisdiction_code pay_latest_balances.jurisdiction_code%type;
349: g_con_original_entry_id pay_latest_balances.original_entry_id%type;
350: g_con_source_id pay_latest_balances.source_id%type;
351: g_con_source_text pay_latest_balances.source_text%type;
352: g_con_source_text2 pay_latest_balances.source_text2%type;
353: g_con_source_number pay_latest_balances.source_number%type;
354: g_con_tax_group pay_latest_balances.tax_group%type;
355: g_con_payroll_id pay_latest_balances.payroll_id%type;
356: g_con_local_unit_id pay_latest_balances.local_unit_id%type;

Line 353: g_con_source_number pay_latest_balances.source_number%type;

349: g_con_original_entry_id pay_latest_balances.original_entry_id%type;
350: g_con_source_id pay_latest_balances.source_id%type;
351: g_con_source_text pay_latest_balances.source_text%type;
352: g_con_source_text2 pay_latest_balances.source_text2%type;
353: g_con_source_number pay_latest_balances.source_number%type;
354: g_con_tax_group pay_latest_balances.tax_group%type;
355: g_con_payroll_id pay_latest_balances.payroll_id%type;
356: g_con_local_unit_id pay_latest_balances.local_unit_id%type;
357: g_con_organization_id pay_latest_balances.organization_id%type;

Line 354: g_con_tax_group pay_latest_balances.tax_group%type;

350: g_con_source_id pay_latest_balances.source_id%type;
351: g_con_source_text pay_latest_balances.source_text%type;
352: g_con_source_text2 pay_latest_balances.source_text2%type;
353: g_con_source_number pay_latest_balances.source_number%type;
354: g_con_tax_group pay_latest_balances.tax_group%type;
355: g_con_payroll_id pay_latest_balances.payroll_id%type;
356: g_con_local_unit_id pay_latest_balances.local_unit_id%type;
357: g_con_organization_id pay_latest_balances.organization_id%type;
358: g_con_source_number2 pay_latest_balances.source_number2%type;

Line 355: g_con_payroll_id pay_latest_balances.payroll_id%type;

351: g_con_source_text pay_latest_balances.source_text%type;
352: g_con_source_text2 pay_latest_balances.source_text2%type;
353: g_con_source_number pay_latest_balances.source_number%type;
354: g_con_tax_group pay_latest_balances.tax_group%type;
355: g_con_payroll_id pay_latest_balances.payroll_id%type;
356: g_con_local_unit_id pay_latest_balances.local_unit_id%type;
357: g_con_organization_id pay_latest_balances.organization_id%type;
358: g_con_source_number2 pay_latest_balances.source_number2%type;
359:

Line 356: g_con_local_unit_id pay_latest_balances.local_unit_id%type;

352: g_con_source_text2 pay_latest_balances.source_text2%type;
353: g_con_source_number pay_latest_balances.source_number%type;
354: g_con_tax_group pay_latest_balances.tax_group%type;
355: g_con_payroll_id pay_latest_balances.payroll_id%type;
356: g_con_local_unit_id pay_latest_balances.local_unit_id%type;
357: g_con_organization_id pay_latest_balances.organization_id%type;
358: g_con_source_number2 pay_latest_balances.source_number2%type;
359:
360: type t_inp_value is record

Line 357: g_con_organization_id pay_latest_balances.organization_id%type;

353: g_con_source_number pay_latest_balances.source_number%type;
354: g_con_tax_group pay_latest_balances.tax_group%type;
355: g_con_payroll_id pay_latest_balances.payroll_id%type;
356: g_con_local_unit_id pay_latest_balances.local_unit_id%type;
357: g_con_organization_id pay_latest_balances.organization_id%type;
358: g_con_source_number2 pay_latest_balances.source_number2%type;
359:
360: type t_inp_value is record
361: (

Line 358: g_con_source_number2 pay_latest_balances.source_number2%type;

354: g_con_tax_group pay_latest_balances.tax_group%type;
355: g_con_payroll_id pay_latest_balances.payroll_id%type;
356: g_con_local_unit_id pay_latest_balances.local_unit_id%type;
357: g_con_organization_id pay_latest_balances.organization_id%type;
358: g_con_source_number2 pay_latest_balances.source_number2%type;
359:
360: type t_inp_value is record
361: (
362: rv_input_name pay_input_values_f.name%type,

Line 4291: from pay_latest_balances plb

4287: plb.payroll_id,
4288: plb.local_unit_id,
4289: plb.organization_id,
4290: plb.source_number2
4291: from pay_latest_balances plb
4292: , per_all_assignments_f ASSIGN
4293: , pay_assignment_actions ACT
4294: , pay_payroll_actions PACT
4295: , pay_assignment_actions OWN_ACT

Line 4345: l_balance_value pay_latest_balances.value%type;

4341: and nvl(plb.source_number2, nvl(g_con_source_number2, -1))
4342: = nvl(g_con_source_number2, -1)
4343: order by plb.latest_balance_id;
4344: --
4345: l_balance_value pay_latest_balances.value%type;
4346: l_bal_owner_asg_action pay_latest_balances.assignment_action_id%type;
4347: --
4348: l_num_of_runs number;
4349: l_bal_con_str varchar2(500); -- Balance context string

Line 4346: l_bal_owner_asg_action pay_latest_balances.assignment_action_id%type;

4342: = nvl(g_con_source_number2, -1)
4343: order by plb.latest_balance_id;
4344: --
4345: l_balance_value pay_latest_balances.value%type;
4346: l_bal_owner_asg_action pay_latest_balances.assignment_action_id%type;
4347: --
4348: l_num_of_runs number;
4349: l_bal_con_str varchar2(500); -- Balance context string
4350: l_balance_expired number;