DBA Data[Home] [Help]

APPS.PAY_US_SOE_BALANCES_PKG dependencies on PAY_US_EARNINGS_AMOUNTS_RBR_V

Line 393: from pay_us_earnings_amounts_rbr_v

389: ,reporting_name_alt
390: ,run_val
391: ,hours_run_val
392: ,element_type_id
393: from pay_us_earnings_amounts_rbr_v
394: where assignment_action_id = c_run_assact_id
395: order by decode(reporting_name_alt, 'Regular Pay', 0,
396: 'Regular Salary',0,
397: 'Regular Wages',0,

Line 415: from pay_us_earnings_amounts_rbr_v pt

411: select reporting_name_alt
412: ,run_val
413: ,hours_run_val
414: ,element_type_id
415: from pay_us_earnings_amounts_rbr_v pt
416: where pt.assignment_action_id = cp_run_action_id
417: order by decode( reporting_name_alt, 'Regular Pay', 0,
418: 'Regular Salary',0,
419: 'Regular Wages',0,

Line 435: from pay_us_earnings_amounts_rbr_v pt

431: CURSOR c_get_pre_earn_ytd_rb(cp_master_action_id number) IS
432: select ytd_val
433: ,pt.reporting_name_alt
434: ,element_type_id
435: from pay_us_earnings_amounts_rbr_v pt
436: where pt.assignment_action_id = cp_master_action_id
437: order by decode( reporting_name_alt, 'Regular Pay', 0,
438: 'Regular Salary',0,
439: 'Regular Wages',0,

Line 597: p_rep_name in pay_us_earnings_amounts_rbr_v.reporting_name_alt%type,

593: -- If the element exists it will return the position otherwise will return
594: -- new index where new element will be stored. Needed to group the earnings
595: -- based on the reporting name
596: PROCEDURE get_position_name (
597: p_rep_name in pay_us_earnings_amounts_rbr_v.reporting_name_alt%type,
598: p_found out nocopy boolean,
599: p_index out nocopy number)
600: IS
601: st_cnt number;