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_US_REPORTING_UTILS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 2837: l_effective_start_date pay_payroll_actions.effective_date%TYPE;

2833: lv_bal_amt number := 0;
2834: l_bal_id number := 0;
2835: l_get boolean := TRUE ;
2836: l_balance_name pay_balance_types.balance_name%TYPE;
2837: l_effective_start_date pay_payroll_actions.effective_date%TYPE;
2838: l_effective_end_date pay_payroll_actions.effective_date%TYPE;
2839: l_exists varchar2(1);
2840:
2841: CURSOR get_effective_date(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

Line 2838: l_effective_end_date pay_payroll_actions.effective_date%TYPE;

2834: l_bal_id number := 0;
2835: l_get boolean := TRUE ;
2836: l_balance_name pay_balance_types.balance_name%TYPE;
2837: l_effective_start_date pay_payroll_actions.effective_date%TYPE;
2838: l_effective_end_date pay_payroll_actions.effective_date%TYPE;
2839: l_exists varchar2(1);
2840:
2841: CURSOR get_effective_date(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
2842: IS

Line 2844: from pay_payroll_actions ppa,

2840:
2841: CURSOR get_effective_date(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
2842: IS
2843: select add_months(effective_date,-12)+1,effective_date
2844: from pay_payroll_actions ppa,
2845: pay_assignment_actions paa
2846: where ppa.payroll_action_id = paa.payroll_action_id
2847: and paa.assignment_action_id = c_assignment_action_id;
2848:

Line 2851: c_start_date pay_payroll_actions.effective_date%TYPE,

2847: and paa.assignment_action_id = c_assignment_action_id;
2848:
2849: /*Bug:3233249*/
2850: CURSOR get_balance_feed_exist(c_balance_name pay_balance_types.balance_name%TYPE,
2851: c_start_date pay_payroll_actions.effective_date%TYPE,
2852: c_end_date pay_payroll_actions.effective_date%TYPE)
2853: IS
2854: select '1' from pay_balance_feeds_f pbf,
2855: pay_balance_types pbt

Line 2852: c_end_date pay_payroll_actions.effective_date%TYPE)

2848:
2849: /*Bug:3233249*/
2850: CURSOR get_balance_feed_exist(c_balance_name pay_balance_types.balance_name%TYPE,
2851: c_start_date pay_payroll_actions.effective_date%TYPE,
2852: c_end_date pay_payroll_actions.effective_date%TYPE)
2853: IS
2854: select '1' from pay_balance_feeds_f pbf,
2855: pay_balance_types pbt
2856: where pbf.balance_type_id = pbt.balance_type_id

Line 2991: from pay_payroll_actions ppa,

2987: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
2988:
2989: select count(*)
2990: into lv_employee_count
2991: from pay_payroll_actions ppa,
2992: pay_assignment_actions paa
2993: where ppa.payroll_action_id = p_payroll_action_id
2994: and paa.tax_unit_id = p_tax_unit_id
2995: and ppa.payroll_action_id = paa.payroll_action_id ;

Line 3064: pay_payroll_actions ppa

3060: FROM ff_archive_item_contexts faic,
3061: ff_archive_items fai,
3062: ff_database_items fdi,
3063: pay_assignment_actions paa,
3064: pay_payroll_actions ppa
3065: WHERE
3066: ppa.payroll_action_id = p_payroll_action_id
3067: and ppa.payroll_action_id = paa.payroll_action_id
3068: and fdi.user_name = 'A_STATE_ABBREV'

Line 3106: pay_payroll_actions ppa,

3102: FROM ff_archive_item_contexts faic,
3103: ff_archive_items fai,
3104: ff_database_items fdi,
3105: pay_assignment_actions paa,
3106: pay_payroll_actions ppa,
3107: ff_archive_items fai1,
3108: ff_database_items fdi1,
3109: ff_archive_item_contexts faic1,
3110: ff_contexts fc,

Line 3174: pay_payroll_actions ppa,

3170: FROM ff_archive_item_contexts faic,
3171: ff_archive_items fai,
3172: ff_database_items fdi,
3173: pay_assignment_actions paa,
3174: pay_payroll_actions ppa,
3175: ff_archive_items fai1,
3176: ff_database_items fdi1,
3177: ff_archive_item_contexts faic1,
3178: ff_contexts fc,

Line 3244: pay_payroll_actions ppa,

3240: FROM ff_archive_item_contexts faic,
3241: ff_archive_items fai,
3242: ff_database_items fdi,
3243: pay_assignment_actions paa,
3244: pay_payroll_actions ppa,
3245: ff_archive_items fai1,
3246: ff_database_items fdi1
3247: --ff_archive_item_contexts faic1,
3248: --ff_contexts fc,

Line 3321: from pay_payroll_actions ppa,

3317: IF p_state = 'MI' or p_state='NM' THEN
3318:
3319: select sum(to_number(nvl(fai.value, '0')) - to_number(nvl(fai1.value, '0')))
3320: into lv_total_wages
3321: from pay_payroll_actions ppa,
3322: pay_assignment_actions paa,
3323: ff_archive_items fai,
3324: ff_archive_items fai1,
3325: ff_database_items fdi,

Line 3451: from pay_payroll_actions ppa,

3447: - to_number(nvl(fai1.value, '0'))
3448: - to_number(nvl(fai2.value, '0'))
3449: ),0)
3450: into p_excess_wages
3451: from pay_payroll_actions ppa,
3452: pay_assignment_actions paa,
3453: ff_archive_items fai,
3454: ff_archive_items fai1,
3455: ff_archive_items fai2,

Line 3474: from pay_payroll_actions ppa,

3470: and fdi2.user_name = 'A_SUI_ER_TAXABLE_PER_JD_GRE_QTD' ;
3471:
3472: select nvl(sum(to_number(nvl(fai.value, '0'))),0)
3473: into p_withholding
3474: from pay_payroll_actions ppa,
3475: pay_assignment_actions paa,
3476: ff_archive_items fai,
3477: ff_database_items fdi
3478: where ppa.payroll_action_id = p_payroll_action_id

Line 3490: from pay_payroll_actions ppa,

3486: + to_number(nvl(fai1.value, '0'))
3487: + to_number(nvl(fai2.value, '0'))
3488: ),0)
3489: into p_workerscomp
3490: from pay_payroll_actions ppa,
3491: pay_assignment_actions paa,
3492: ff_archive_items fai,
3493: ff_archive_items fai1,
3494: ff_archive_items fai2,

Line 3525: select 'Y' from pay_payroll_actions

3521: p_sui_taxable out nocopy number
3522: )return number is
3523:
3524: CURSOR cur_fl_sqwl IS
3525: select 'Y' from pay_payroll_actions
3526: where payroll_action_id=p_payroll_action_id
3527: and report_type='SQWL'
3528: and report_qualifier='FL';
3529:

Line 3531: select 'Y' from pay_payroll_actions

3527: and report_type='SQWL'
3528: and report_qualifier='FL';
3529:
3530: CURSOR cur_oh_sqwl IS
3531: select 'Y' from pay_payroll_actions
3532: where payroll_action_id=p_payroll_action_id
3533: and report_type='SQWL'
3534: and report_qualifier='OH';
3535:

Line 3552: from pay_payroll_actions ppa,

3548: into p_sui_subj,
3549: p_sui_pre_tax,
3550: p_sui_taxable,
3551: p_sui_gross
3552: from pay_payroll_actions ppa,
3553: pay_assignment_actions paa,
3554: ff_archive_items fai,
3555: ff_archive_items fai1,
3556: ff_archive_items fai2,

Line 3590: from pay_payroll_actions ppa,

3586: hr_utility.trace('Getting the Adjusted Taxable for Florida');
3587:
3588: select nvl(sum(to_number(nvl(fai.value, '0'))),0)
3589: into p_sui_taxable
3590: from pay_payroll_actions ppa,
3591: pay_assignment_actions paa,
3592: ff_archive_items fai,
3593: ff_database_items fdi
3594: where ppa.payroll_action_id = p_payroll_action_id

Line 3618: from pay_payroll_actions ppa,

3614: hr_utility.trace('Getting the Out of State Taxable for Ohio');
3615:
3616: select nvl(sum(to_number(nvl(fai.value, '0'))),0)
3617: into p_sui_taxable
3618: from pay_payroll_actions ppa,
3619: pay_assignment_actions paa,
3620: ff_archive_items fai,
3621: ff_database_items fdi
3622: where ppa.payroll_action_id = p_payroll_action_id