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_ELEMENT_TYPES_F

Line 277: l_element_type_id pay_element_types_f.element_type_id%TYPE;

273: return number IS
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

Line 283: FROM pay_element_types_f pet

279: l_spouse VARCHAR2(10);
280:
281: CURSOR csr_paye_tax_element IS
282: SELECT pet.element_type_id
283: FROM pay_element_types_f pet
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:

Line 351: l_element_type_id pay_element_types_f.element_type_id%TYPE;

347: ,p_date IN DATE
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

Line 357: FROM pay_element_types_f pet

353: l_tax_scale VARCHAR2(10);
354:
355: CURSOR csr_paye_tax_element IS
356: SELECT pet.element_type_id
357: FROM pay_element_types_f pet
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:

Line 1986: pay_element_types_f pet,

1982: pec.classification_name
1983: from pay_element_entries_f pee,
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

Line 2291: pay_element_types_f pet,

2287: DECODE(pec.classification_name,'Earnings',pec2.classification_name,NULL) label
2288: from pay_element_entries_f pee,
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,

Line 2327: pay_element_types_f pet,

2323: pec.classification_name
2324: from pay_element_entries_f pee,
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,

Line 2362: pay_element_types_f pet,

2358: pec.classification_name
2359: from pay_element_entries_f pee,
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

Line 2808: pay_element_types_f pet,

2804: cursor check_fixed_deduction(p_assignment_id in number, p_date_earned in date)
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,

Line 2852: pay_element_types_f pet,

2848: /* Bug 4374115 - End */
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 */

Line 3068: pay_element_types_f pet,

3064: CURSOR Cr_value IS (
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

Line 3250: from pay_element_types_f pet,

3246: p_spread_earning in number) return number is
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

Line 3286: from pay_element_types_f pet,

3282:
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

Line 3398: from pay_element_types_f pet,

3394: p_spread_earning in number) return number is
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

Line 3457: from pay_element_types_f pet,

3453:
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

Line 3539: pay_element_types_f pet,

3535: IS
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'

Line 3720: pay_element_types_f pet,

3716: pee.creator_type
3717: FROM pay_element_entries_f pee,
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

Line 4226: pay_element_types_f pet

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
4230: and piv.name = 'Spread'

Line 4250: pay_element_types_f pet

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
4254: and piv.name = 'Total'

Line 4563: FROM pay_element_types_f pet

4559: AND g_date BETWEEN piv.effective_start_date AND piv.effective_end_date;
4560:
4561: CURSOR csr_paye_tax_element IS
4562: SELECT pet.element_type_id
4563: FROM pay_element_types_f pet
4564: WHERE pet.element_name = 'Tax Information'
4565: AND g_date BETWEEN pet.effective_start_date AND pet.effective_end_date
4566: AND legislation_code = 'AU';
4567:

Line 4568: CURSOR csr_ele_entries(p_element_type_id IN pay_element_types_f.element_type_id%TYPE,p_input_value_id IN NUMBER) IS

4564: WHERE pet.element_name = 'Tax Information'
4565: AND g_date BETWEEN pet.effective_start_date AND pet.effective_end_date
4566: AND legislation_code = 'AU';
4567:
4568: CURSOR csr_ele_entries(p_element_type_id IN pay_element_types_f.element_type_id%TYPE,p_input_value_id IN NUMBER) IS
4569: select pee.assignment_id
4570: ,pee.element_entry_id
4571: ,pee.effective_start_date
4572: ,pee.effective_end_date

Line 4587: CURSOR csr_asg_curr_scale(p_element_type_id IN pay_element_types_f.element_type_id%TYPE,p_input_value_id IN NUMBER) IS

4583: and peev.effective_end_date = pee.effective_end_date
4584: )
4585: order by assignment_id;
4586:
4587: CURSOR csr_asg_curr_scale(p_element_type_id IN pay_element_types_f.element_type_id%TYPE,p_input_value_id IN NUMBER) IS
4588: select pee.assignment_id
4589: from pay_element_entries_f pee
4590: where pee.ELEMENT_TYPE_ID = p_element_type_id
4591: and g_date between pee.effective_start_date and pee.effective_end_date

Line 4614: CURSOR csr_fut_ele_entries(p_element_type_id IN pay_element_types_f.element_type_id%TYPE,p_input_value_id IN NUMBER) IS

4610: and peev1.effective_end_date = pee1.effective_end_date
4611: )
4612: order by assignment_id;
4613:
4614: CURSOR csr_fut_ele_entries(p_element_type_id IN pay_element_types_f.element_type_id%TYPE,p_input_value_id IN NUMBER) IS
4615: select pee.assignment_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date
4616: from pay_element_entries_f pee
4617: where pee.ELEMENT_TYPE_ID = p_element_type_id
4618: and g_date between pee.effective_start_date and pee.effective_end_date