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 2818: l_effective_start_date pay_payroll_actions.effective_date%TYPE;

2814: lv_bal_amt number := 0;
2815: l_bal_id number := 0;
2816: l_get boolean := TRUE ;
2817: l_balance_name pay_balance_types.balance_name%TYPE;
2818: l_effective_start_date pay_payroll_actions.effective_date%TYPE;
2819: l_effective_end_date pay_payroll_actions.effective_date%TYPE;
2820: l_exists varchar2(1);
2821:
2822: CURSOR get_effective_date(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

Line 2819: l_effective_end_date pay_payroll_actions.effective_date%TYPE;

2815: l_bal_id number := 0;
2816: l_get boolean := TRUE ;
2817: l_balance_name pay_balance_types.balance_name%TYPE;
2818: l_effective_start_date pay_payroll_actions.effective_date%TYPE;
2819: l_effective_end_date pay_payroll_actions.effective_date%TYPE;
2820: l_exists varchar2(1);
2821:
2822: CURSOR get_effective_date(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
2823: IS

Line 2825: from pay_payroll_actions ppa,

2821:
2822: CURSOR get_effective_date(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
2823: IS
2824: select add_months(effective_date,-12)+1,effective_date
2825: from pay_payroll_actions ppa,
2826: pay_assignment_actions paa
2827: where ppa.payroll_action_id = paa.payroll_action_id
2828: and paa.assignment_action_id = c_assignment_action_id;
2829:

Line 2832: c_start_date pay_payroll_actions.effective_date%TYPE,

2828: and paa.assignment_action_id = c_assignment_action_id;
2829:
2830: /*Bug:3233249*/
2831: CURSOR get_balance_feed_exist(c_balance_name pay_balance_types.balance_name%TYPE,
2832: c_start_date pay_payroll_actions.effective_date%TYPE,
2833: c_end_date pay_payroll_actions.effective_date%TYPE)
2834: IS
2835: select '1' from pay_balance_feeds_f pbf,
2836: pay_balance_types pbt

Line 2833: c_end_date pay_payroll_actions.effective_date%TYPE)

2829:
2830: /*Bug:3233249*/
2831: CURSOR get_balance_feed_exist(c_balance_name pay_balance_types.balance_name%TYPE,
2832: c_start_date pay_payroll_actions.effective_date%TYPE,
2833: c_end_date pay_payroll_actions.effective_date%TYPE)
2834: IS
2835: select '1' from pay_balance_feeds_f pbf,
2836: pay_balance_types pbt
2837: where pbf.balance_type_id = pbt.balance_type_id

Line 2972: from pay_payroll_actions ppa,

2968: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
2969:
2970: select count(*)
2971: into lv_employee_count
2972: from pay_payroll_actions ppa,
2973: pay_assignment_actions paa
2974: where ppa.payroll_action_id = p_payroll_action_id
2975: and paa.tax_unit_id = p_tax_unit_id
2976: and ppa.payroll_action_id = paa.payroll_action_id ;

Line 3045: pay_payroll_actions ppa

3041: FROM ff_archive_item_contexts faic,
3042: ff_archive_items fai,
3043: ff_database_items fdi,
3044: pay_assignment_actions paa,
3045: pay_payroll_actions ppa
3046: WHERE
3047: ppa.payroll_action_id = p_payroll_action_id
3048: and ppa.payroll_action_id = paa.payroll_action_id
3049: and fdi.user_name = 'A_STATE_ABBREV'

Line 3079: pay_payroll_actions ppa,

3075: FROM ff_archive_item_contexts faic,
3076: ff_archive_items fai,
3077: ff_database_items fdi,
3078: pay_assignment_actions paa,
3079: pay_payroll_actions ppa,
3080: ff_archive_items fai1,
3081: ff_database_items fdi1,
3082: ff_archive_item_contexts faic1,
3083: ff_contexts fc,

Line 3161: from pay_payroll_actions ppa,

3157: IF p_state = 'MI' or p_state='NM' THEN
3158:
3159: select sum(to_number(nvl(fai.value, '0')) - to_number(nvl(fai1.value, '0')))
3160: into lv_total_wages
3161: from pay_payroll_actions ppa,
3162: pay_assignment_actions paa,
3163: ff_archive_items fai,
3164: ff_archive_items fai1,
3165: ff_database_items fdi,

Line 3270: from pay_payroll_actions ppa,

3266: - to_number(nvl(fai1.value, '0'))
3267: - to_number(nvl(fai2.value, '0'))
3268: ),0)
3269: into p_excess_wages
3270: from pay_payroll_actions ppa,
3271: pay_assignment_actions paa,
3272: ff_archive_items fai,
3273: ff_archive_items fai1,
3274: ff_archive_items fai2,

Line 3293: from pay_payroll_actions ppa,

3289: and fdi2.user_name = 'A_SUI_ER_TAXABLE_PER_JD_GRE_QTD' ;
3290:
3291: select nvl(sum(to_number(nvl(fai.value, '0'))),0)
3292: into p_withholding
3293: from pay_payroll_actions ppa,
3294: pay_assignment_actions paa,
3295: ff_archive_items fai,
3296: ff_database_items fdi
3297: where ppa.payroll_action_id = p_payroll_action_id

Line 3309: from pay_payroll_actions ppa,

3305: + to_number(nvl(fai1.value, '0'))
3306: + to_number(nvl(fai2.value, '0'))
3307: ),0)
3308: into p_workerscomp
3309: from pay_payroll_actions ppa,
3310: pay_assignment_actions paa,
3311: ff_archive_items fai,
3312: ff_archive_items fai1,
3313: ff_archive_items fai2,

Line 3350: from pay_payroll_actions ppa,

3346: into p_sui_subj,
3347: p_sui_pre_tax,
3348: p_sui_taxable,
3349: p_sui_gross
3350: from pay_payroll_actions ppa,
3351: pay_assignment_actions paa,
3352: ff_archive_items fai,
3353: ff_archive_items fai1,
3354: ff_archive_items fai2,