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_FR_ATTESTATION_ASSEDIC dependencies on PAY_BALANCE_PKG

Line 361: pay_balance_pkg.get_value(g_npil_payment_id,max(paa.assignment_action_id)) npil,

357:
358: --Changed the cursor to fetch both Transactional and contractual balances --Bug#2953140.
359: Cursor csr_get_indemnities Is
360: Select
361: pay_balance_pkg.get_value(g_npil_payment_id,max(paa.assignment_action_id)) npil,
362: pay_balance_pkg.get_value(g_legal_term_indemnity_id,max(paa.assignment_action_id)) legal,
363: pay_balance_pkg.get_value(g_conventional_indemnity_id,max(paa.assignment_action_id)) conventional,
364: pay_balance_pkg.get_value(g_contractual_indemnity_id,max(paa.assignment_action_id)) contractual,
365: pay_balance_pkg.get_value(g_transactional_indemnity_id,max(paa.assignment_action_id)) transactional

Line 362: pay_balance_pkg.get_value(g_legal_term_indemnity_id,max(paa.assignment_action_id)) legal,

358: --Changed the cursor to fetch both Transactional and contractual balances --Bug#2953140.
359: Cursor csr_get_indemnities Is
360: Select
361: pay_balance_pkg.get_value(g_npil_payment_id,max(paa.assignment_action_id)) npil,
362: pay_balance_pkg.get_value(g_legal_term_indemnity_id,max(paa.assignment_action_id)) legal,
363: pay_balance_pkg.get_value(g_conventional_indemnity_id,max(paa.assignment_action_id)) conventional,
364: pay_balance_pkg.get_value(g_contractual_indemnity_id,max(paa.assignment_action_id)) contractual,
365: pay_balance_pkg.get_value(g_transactional_indemnity_id,max(paa.assignment_action_id)) transactional
366: From

Line 363: pay_balance_pkg.get_value(g_conventional_indemnity_id,max(paa.assignment_action_id)) conventional,

359: Cursor csr_get_indemnities Is
360: Select
361: pay_balance_pkg.get_value(g_npil_payment_id,max(paa.assignment_action_id)) npil,
362: pay_balance_pkg.get_value(g_legal_term_indemnity_id,max(paa.assignment_action_id)) legal,
363: pay_balance_pkg.get_value(g_conventional_indemnity_id,max(paa.assignment_action_id)) conventional,
364: pay_balance_pkg.get_value(g_contractual_indemnity_id,max(paa.assignment_action_id)) contractual,
365: pay_balance_pkg.get_value(g_transactional_indemnity_id,max(paa.assignment_action_id)) transactional
366: From
367: pay_payroll_actions ppa ,

Line 364: pay_balance_pkg.get_value(g_contractual_indemnity_id,max(paa.assignment_action_id)) contractual,

360: Select
361: pay_balance_pkg.get_value(g_npil_payment_id,max(paa.assignment_action_id)) npil,
362: pay_balance_pkg.get_value(g_legal_term_indemnity_id,max(paa.assignment_action_id)) legal,
363: pay_balance_pkg.get_value(g_conventional_indemnity_id,max(paa.assignment_action_id)) conventional,
364: pay_balance_pkg.get_value(g_contractual_indemnity_id,max(paa.assignment_action_id)) contractual,
365: pay_balance_pkg.get_value(g_transactional_indemnity_id,max(paa.assignment_action_id)) transactional
366: From
367: pay_payroll_actions ppa ,
368: pay_assignment_actions paa

Line 365: pay_balance_pkg.get_value(g_transactional_indemnity_id,max(paa.assignment_action_id)) transactional

361: pay_balance_pkg.get_value(g_npil_payment_id,max(paa.assignment_action_id)) npil,
362: pay_balance_pkg.get_value(g_legal_term_indemnity_id,max(paa.assignment_action_id)) legal,
363: pay_balance_pkg.get_value(g_conventional_indemnity_id,max(paa.assignment_action_id)) conventional,
364: pay_balance_pkg.get_value(g_contractual_indemnity_id,max(paa.assignment_action_id)) contractual,
365: pay_balance_pkg.get_value(g_transactional_indemnity_id,max(paa.assignment_action_id)) transactional
366: From
367: pay_payroll_actions ppa ,
368: pay_assignment_actions paa
369: Where ppa.payroll_action_id = paa.payroll_action_id