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_AU_PAYE_FF dependencies on PAY_INPUT_VALUES_F

Line 278: l_input_value_id pay_input_values_f.input_value_id%TYPE;

274:
275: l_rate number := 0 ;
276: l_code varchar2(1);
277: l_element_type_id pay_element_types_f.element_type_id%TYPE;
278: l_input_value_id pay_input_values_f.input_value_id%TYPE;
279: l_spouse VARCHAR2(10);
280:
281: CURSOR csr_paye_tax_element IS
282: SELECT pet.element_type_id

Line 288: CURSOR csr_paye_spouse_input_value(p_element_type_id pay_input_values_f.element_type_id%TYPE) IS

284: WHERE pet.element_name = 'Tax Information'
285: AND p_date BETWEEN pet.effective_start_date AND pet.effective_end_date
286: AND legislation_code = 'AU';
287:
288: CURSOR csr_paye_spouse_input_value(p_element_type_id pay_input_values_f.element_type_id%TYPE) IS
289: SELECT piv.input_value_id
290: FROM pay_input_values_f piv
291: WHERE piv.element_type_id = p_element_type_id
292: AND p_date BETWEEN piv.effective_start_date AND piv.effective_end_date

Line 290: FROM pay_input_values_f piv

286: AND legislation_code = 'AU';
287:
288: CURSOR csr_paye_spouse_input_value(p_element_type_id pay_input_values_f.element_type_id%TYPE) IS
289: SELECT piv.input_value_id
290: FROM pay_input_values_f piv
291: WHERE piv.element_type_id = p_element_type_id
292: AND p_date BETWEEN piv.effective_start_date AND piv.effective_end_date
293: AND piv.name = 'Spouse';
294:

Line 352: l_input_value_id pay_input_values_f.input_value_id%TYPE;

348: )
349: return varchar2 IS
350:
351: l_element_type_id pay_element_types_f.element_type_id%TYPE;
352: l_input_value_id pay_input_values_f.input_value_id%TYPE;
353: l_tax_scale VARCHAR2(10);
354:
355: CURSOR csr_paye_tax_element IS
356: SELECT pet.element_type_id

Line 362: CURSOR csr_paye_txscale_input_value(p_element_type_id pay_input_values_f.element_type_id%TYPE) IS

358: WHERE pet.element_name = 'Tax Information'
359: AND p_date BETWEEN pet.effective_start_date AND pet.effective_end_date
360: AND legislation_code = 'AU';
361:
362: CURSOR csr_paye_txscale_input_value(p_element_type_id pay_input_values_f.element_type_id%TYPE) IS
363: SELECT piv.input_value_id
364: FROM pay_input_values_f piv
365: WHERE piv.element_type_id = p_element_type_id
366: AND p_date BETWEEN piv.effective_start_date AND piv.effective_end_date

Line 364: FROM pay_input_values_f piv

360: AND legislation_code = 'AU';
361:
362: CURSOR csr_paye_txscale_input_value(p_element_type_id pay_input_values_f.element_type_id%TYPE) IS
363: SELECT piv.input_value_id
364: FROM pay_input_values_f piv
365: WHERE piv.element_type_id = p_element_type_id
366: AND p_date BETWEEN piv.effective_start_date AND piv.effective_end_date
367: AND piv.name = 'Tax Scale';
368:

Line 1988: pay_input_values_f piv,

1984: pay_element_entry_values_f peev,
1985: pay_element_links_f pelf,
1986: pay_element_types_f pet,
1987: pay_element_classifications pec,
1988: pay_input_values_f piv,
1989: pay_assignment_actions paa
1990: where paa.assignment_action_id = p_assignment_action_id
1991: and pee.assignment_id = paa.assignment_id
1992: and pee.creator_type IN ('EE','RR')

Line 2293: pay_input_values_f piv,

2289: pay_element_entry_values_f peev,
2290: pay_element_links_f pelf,
2291: pay_element_types_f pet,
2292: pay_element_classifications pec,
2293: pay_input_values_f piv,
2294: pay_assignment_actions paa,
2295: pay_sub_classification_rules_f psc,
2296: pay_element_classifications pec2 /* Bug 9922156 */
2297: where paa.assignment_action_id = p_assignment_action_id

Line 2329: pay_input_values_f piv,

2325: pay_element_entry_values_f peev,
2326: pay_element_links_f pelf,
2327: pay_element_types_f pet,
2328: pay_element_classifications pec,
2329: pay_input_values_f piv,
2330: pay_assignment_actions paa,
2331: pay_sub_classification_rules_f psc,
2332: pay_element_classifications pec2
2333: where paa.assignment_action_id = p_assignment_action_id

Line 2364: pay_input_values_f piv,

2360: pay_element_entry_values_f peev,
2361: pay_element_links_f pelf,
2362: pay_element_types_f pet,
2363: pay_element_classifications pec,
2364: pay_input_values_f piv,
2365: pay_assignment_actions paa
2366: where paa.assignment_action_id = p_assignment_action_id
2367: and pee.assignment_id = paa.assignment_id
2368: and pee.creator_type IN ('EE','RR')

Line 2809: pay_input_values_f piv,

2805: is
2806: select 'Y'
2807: from
2808: pay_element_types_f pet,
2809: pay_input_values_f piv,
2810: pay_run_result_values prrv,
2811: pay_run_results prr,
2812: pay_assignment_actions paa,
2813: pay_payroll_actions ppa,

Line 2853: pay_input_values_f piv,

2849: and not exists(
2850: select piv.name
2851: from
2852: pay_element_types_f pet,
2853: pay_input_values_f piv,
2854: pay_input_values_f piv1,
2855: pay_element_links_f pel, /* Bug#2563515 */
2856: pay_element_entries_f peef, /* Bug#2563515 */
2857: pay_element_entry_values_f peev,

Line 2854: pay_input_values_f piv1,

2850: select piv.name
2851: from
2852: pay_element_types_f pet,
2853: pay_input_values_f piv,
2854: pay_input_values_f piv1,
2855: pay_element_links_f pel, /* Bug#2563515 */
2856: pay_element_entries_f peef, /* Bug#2563515 */
2857: pay_element_entry_values_f peev,
2858: pay_element_entry_values_f peev1

Line 3069: pay_input_values_f piv

3065: SELECT prv.result_value
3066: from pay_run_results prr,
3067: pay_run_result_values prv,
3068: pay_element_types_f pet,
3069: pay_input_values_f piv
3070: where prr.assignment_action_id = p_assignment_action_id
3071: and prv.run_result_id = prr.run_result_id
3072: and prv.input_value_id = piv.input_value_id
3073: and prr.element_type_id = pet.element_type_id

Line 3080: FROM pay_input_values_f pivf, per_pay_bases ppb

3076: and pet.element_name= 'Normal Hours');
3077:
3078: CURSOR Cr_element_type_id IS (
3079: SELECT pivf.element_type_id /*Bug# 3665680*/
3080: FROM pay_input_values_f pivf, per_pay_bases ppb
3081: WHERE pivf.input_value_id = ppb.input_value_id
3082: AND ppb.pay_basis_id = p_pay_bases_id);
3083:
3084: BEGIN

Line 3251: pay_input_values_f piv,

3247:
3248: cursor get_period_spread_over is
3249: select prv.RESULT_VALUE period_spread_over, prr.run_result_id, pee.creator_type
3250: from pay_element_types_f pet,
3251: pay_input_values_f piv,
3252: pay_run_result_values prv,
3253: pay_run_results prr,
3254: pay_element_entries_f pee
3255: where prr.assignment_action_id=p_assignment_action_id

Line 3273: from pay_input_values_f piv,

3269: and p_date_paid between pee.effective_start_date and pee.effective_end_date;
3270:
3271: cursor get_spread_earning(p_run_result_id pay_run_results.run_result_id%type) is
3272: select prv.RESULT_VALUE
3273: from pay_input_values_f piv,
3274: pay_run_result_values prv,
3275: pay_run_results prr
3276: where prr.RUN_RESULT_ID = p_run_result_id
3277: and prr.RUN_RESULT_ID = prv.RUN_RESULT_ID

Line 3287: pay_input_values_f piv,

3283: /* new cursor for bug 6669058 */
3284: cursor get_retro_spread_earning is
3285: select nvl(sum(prv.RESULT_VALUE),0)
3286: from pay_element_types_f pet,
3287: pay_input_values_f piv,
3288: pay_run_result_values prv,
3289: pay_run_results prr,
3290: pay_element_entries_f pee
3291: where prr.assignment_action_id=p_assignment_action_id

Line 3399: pay_input_values_f piv,

3395:
3396: cursor get_retro_spread_earning is
3397: select nvl(sum(prv.RESULT_VALUE),0)
3398: from pay_element_types_f pet,
3399: pay_input_values_f piv,
3400: pay_run_result_values prv,
3401: pay_run_results prr,
3402: pay_element_entries_f pee
3403: where prr.assignment_action_id=p_assignment_action_id

Line 3458: pay_input_values_f piv,

3454: cursor etp_pay_csr ( c_assignment_id per_all_assignments_f.assignment_id%type,
3455: c_date_earned date) is
3456: select peev.screen_entry_value
3457: from pay_element_types_f pet,
3458: pay_input_values_f piv,
3459: pay_element_entries_f pee,
3460: pay_element_entry_values_f peev
3461: where pee.assignment_id = c_assignment_id
3462: and piv.name ='Pay ETP Components'

Line 3540: pay_input_values_f piv

3536: select prv.result_value
3537: from pay_run_results prr,
3538: pay_run_result_values prv,
3539: pay_element_types_f pet,
3540: pay_input_values_f piv
3541: where prr.assignment_action_id = c_assignment_action_id
3542: and prr.element_type_id = pet.element_type_id
3543: and pet.element_name = 'AU Average Earnings'
3544: and pet.legislation_code = 'AU'

Line 3722: pay_input_values_f piv,

3718: pay_element_entry_values_f peev,
3719: pay_element_links_f pelf,
3720: pay_element_types_f pet,
3721: pay_element_classifications pec,
3722: pay_input_values_f piv,
3723: pay_sub_classification_rules_f psc,
3724: pay_element_classifications pec2
3725: WHERE pee.assignment_id = c_assignment_id
3726: AND pee.creator_type IN ('EE','RR')

Line 3752: ,pay_input_values_f pivf

3748: IS
3749: SELECT peev.screen_entry_value
3750: FROM pay_element_entries_f pee
3751: ,pay_element_entry_values_f peev
3752: ,pay_input_values_f pivf
3753: WHERE pee.element_entry_id = c_element_entry_id
3754: AND pee.assignment_id = c_assignment_id
3755: AND pee.creator_type = 'EE'
3756: AND pee.element_entry_id = peev.element_entry_id

Line 3772: ,pay_input_values_f pivf

3768: IS
3769: SELECT prrv.result_value
3770: FROM pay_run_results prr
3771: ,pay_run_result_values prrv
3772: ,pay_input_values_f pivf
3773: ,pay_element_entries_f pee
3774: WHERE pee.element_entry_id = c_element_entry_id
3775: AND pee.assignment_id = c_assignment_id
3776: AND pee.creator_type = 'RR'

Line 4225: pay_input_values_f piv,

4221: cursor get_retro_spread is
4222: select prv.result_value
4223: from pay_run_results prr,
4224: pay_run_result_values prv,
4225: pay_input_values_f piv,
4226: pay_element_types_f pet
4227: where prr.assignment_action_id = p_assignment_action_id
4228: and prr.run_result_id = prv.run_result_id
4229: and prv.input_value_id = piv.input_value_id

Line 4249: pay_input_values_f piv,

4245: cursor get_retro_total is
4246: select prv.result_value
4247: from pay_run_results prr,
4248: pay_run_result_values prv,
4249: pay_input_values_f piv,
4250: pay_element_types_f pet
4251: where prr.assignment_action_id = p_assignment_action_id
4252: and prr.run_result_id = prv.run_result_id
4253: and prv.input_value_id = piv.input_value_id

Line 4554: CURSOR csr_paye_tax_input_values(p_element_type_id pay_input_values_f.element_type_id%TYPE) IS

4550: l_no_managers_warning boolean;
4551: l_other_manager_warning boolean;
4552: not_inserted boolean := TRUE;
4553:
4554: CURSOR csr_paye_tax_input_values(p_element_type_id pay_input_values_f.element_type_id%TYPE) IS
4555: SELECT piv.input_value_id
4556: ,piv.name
4557: FROM pay_input_values_f piv
4558: WHERE piv.element_type_id = p_element_type_id

Line 4557: FROM pay_input_values_f piv

4553:
4554: CURSOR csr_paye_tax_input_values(p_element_type_id pay_input_values_f.element_type_id%TYPE) IS
4555: SELECT piv.input_value_id
4556: ,piv.name
4557: FROM pay_input_values_f piv
4558: WHERE piv.element_type_id = p_element_type_id
4559: AND g_date BETWEEN piv.effective_start_date AND piv.effective_end_date;
4560:
4561: CURSOR csr_paye_tax_element IS