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_ASSIGNMENT_ACTIONS

Line 2310: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,

2306: AND fdi.user_name = c_user_name;
2307:
2308: CURSOR get_archived_values(
2309: c_user_entity_id ff_database_items.user_entity_id%type,
2310: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
2311: c_tax_unit_id hr_organization_units.organization_id%type)
2312: IS
2313: SELECT target.value
2314: FROM ff_archive_item_contexts con2,

Line 2328: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,

2324: /*context of tax_unit_id */
2325:
2326: CURSOR get_jd_archived_values(
2327: c_user_entity_id ff_database_items.user_entity_id%type,
2328: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
2329: c_tax_unit_id hr_organization_units.organization_id%type,
2330: c_jurisdiction_code varchar2)
2331: IS
2332: SELECT target.value

Line 2822: CURSOR get_effective_date(c_assignment_action_id pay_assignment_actions.assignment_action_id%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
2824: select add_months(effective_date,-12)+1,effective_date
2825: from pay_payroll_actions ppa,
2826: pay_assignment_actions paa

Line 2826: pay_assignment_actions paa

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:
2830: /*Bug:3233249*/

Line 2973: pay_assignment_actions paa

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 ;
2977:

Line 2995: from pay_assignment_actions paa

2991:
2992: cursor get_all_assignment (cur_payroll_action_id number, cur_tax_unit_id number)
2993: is
2994: Select paa.assignment_action_id
2995: from pay_assignment_actions paa
2996: where payroll_action_id = cur_payroll_action_id
2997: and tax_unit_id = cur_tax_unit_id;
2998:
2999: BEGIN

Line 3044: pay_assignment_actions paa,

3040: SELECT count(*)
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

Line 3078: pay_assignment_actions paa,

3074: sum(to_number(nvl(fai1.value,'0')))
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,

Line 3162: pay_assignment_actions paa,

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,
3166: ff_database_items fdi1

Line 3271: pay_assignment_actions paa,

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,
3275: ff_database_items fdi,

Line 3294: pay_assignment_actions paa,

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
3298: and ppa.payroll_action_id = paa.payroll_action_id

Line 3310: pay_assignment_actions paa,

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,
3314: ff_database_items fdi,

Line 3351: pay_assignment_actions paa,

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,
3355: ff_archive_items fai3,