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_ENTRY_VALUES_F

Line 303: pay_element_entry_values_f eev0

299: select
300: eev0.screen_entry_value
301: FROM
302: pay_element_entries_f pee,
303: pay_element_entry_values_f eev0
304: WHERE
305: eev0.element_entry_id = pee.element_entry_id
306: and eev0.input_value_id = p_inp_value_id
307: and pee.element_entry_id = p_element_entry_id

Line 377: pay_element_entry_values_f eev0

373: select
374: eev0.screen_entry_value
375: FROM
376: pay_element_entries_f pee,
377: pay_element_entry_values_f eev0
378: WHERE
379: eev0.element_entry_id = pee.element_entry_id
380: and eev0.input_value_id = p_inp_value_id
381: and pee.element_entry_id = p_element_entry_id

Line 1984: pay_element_entry_values_f peev,

1980: select pee.element_entry_id,
1981: peev.screen_entry_value retro_amount,
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,

Line 2289: pay_element_entry_values_f peev,

2285: peev.screen_entry_value retro_amount,
2286: pec.classification_name,
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,

Line 2325: pay_element_entry_values_f peev,

2321: select pee.element_entry_id,
2322: peev.screen_entry_value retro_amount,
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,

Line 2360: pay_element_entry_values_f peev,

2356: select pee.element_entry_id,
2357: peev.screen_entry_value retro_amount,
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,

Line 2857: pay_element_entry_values_f peev,

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
2859: where pet.element_name = 'Extra Withholding Payments'
2860: and pet.element_type_id= piv.element_type_id
2861: and pet.element_type_id = pel.element_type_id /* Bug#2563515 */

Line 2858: pay_element_entry_values_f peev1

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
2859: where pet.element_name = 'Extra Withholding Payments'
2860: and pet.element_type_id= piv.element_type_id
2861: and pet.element_type_id = pel.element_type_id /* Bug#2563515 */
2862: and pel.element_link_id = peef.element_link_id /* Bug#2563515 */

Line 3460: pay_element_entry_values_f peev

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'
3463: and piv.legislation_code='AU'
3464: and piv.element_type_id = pet.element_type_id

Line 3475: l_etp_pay pay_element_entry_values_f.screen_entry_value%type;

3471: and c_date_earned between pee.effective_start_date and pee.effective_end_date
3472: and c_date_earned between peev.effective_start_date and peev.effective_end_date
3473: and rownum = 1;
3474:
3475: l_etp_pay pay_element_entry_values_f.screen_entry_value%type;
3476:
3477: begin
3478:
3479: open etp_pay_csr (p_assignment_id, p_date_earned);

Line 3718: pay_element_entry_values_f peev,

3714: SELECT pee.element_entry_id,
3715: peev.screen_entry_value retro_amount,
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,

Line 3751: ,pay_element_entry_values_f peev

3747: ,c_date_earned IN DATE )
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'

Line 4519: type screen_entry_values is table of pay_element_entry_values_f.screen_entry_value%TYPE index by binary_integer;

4515: l_business_group_name per_business_groups.name%type;
4516: l_run_mode VARCHAR2(60);
4517:
4518: type number_table is table of number not null index by binary_integer;
4519: type screen_entry_values is table of pay_element_entry_values_f.screen_entry_value%TYPE index by binary_integer;
4520: l_inp_value_id_table number_table;
4521: l_element_type_id NUMBER :=0;
4522: l_effective_start_date DATE;
4523: l_effective_end_date DATE;

Line 4579: select 1 from pay_element_entry_values_f peev

4575: where pee.ELEMENT_TYPE_ID = p_element_type_id
4576: and g_date between pee.effective_start_date and pee.effective_end_date
4577: and pee.effective_end_date = to_date('31-12-4712','dd-mm-yyyy')
4578: and exists (
4579: select 1 from pay_element_entry_values_f peev
4580: where peev.element_entry_id = pee.element_entry_id
4581: and peev.INPUT_VALUE_ID = p_input_value_id and peev.SCREEN_ENTRY_VALUE = '7'
4582: and peev.effective_start_date = pee.effective_start_date
4583: and peev.effective_end_date = pee.effective_end_date

Line 4594: select 1 from pay_element_entry_values_f peev

4590: where pee.ELEMENT_TYPE_ID = p_element_type_id
4591: and g_date between pee.effective_start_date and pee.effective_end_date
4592: and pee.effective_start_date = g_date
4593: and exists (
4594: select 1 from pay_element_entry_values_f peev
4595: where peev.element_entry_id = pee.element_entry_id
4596: and peev.INPUT_VALUE_ID = p_input_value_id and peev.SCREEN_ENTRY_VALUE = '2'
4597: and peev.effective_start_date = pee.effective_start_date
4598: and peev.effective_end_date = pee.effective_end_date

Line 4602: pay_element_entry_values_f peev1,

4598: and peev.effective_end_date = pee.effective_end_date
4599: )
4600: and exists (
4601: select 1 from
4602: pay_element_entry_values_f peev1,
4603: pay_element_entries_f pee1
4604: where pee.ELEMENT_TYPE_ID = p_element_type_id
4605: and g_date-1 between pee1.effective_start_date and pee1.effective_end_date
4606: and peev1.element_entry_id = pee1.element_entry_id

Line 4620: select 1 from pay_element_entry_values_f peev

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
4619: and exists (
4620: select 1 from pay_element_entry_values_f peev
4621: where peev.element_entry_id = pee.element_entry_id
4622: and peev.INPUT_VALUE_ID = p_input_value_id and peev.SCREEN_ENTRY_VALUE = '7'
4623: and peev.effective_start_date = pee.effective_start_date
4624: and peev.effective_end_date = pee.effective_end_date

Line 4660: pay_element_entry_values_f eev0 ,

4656: eev14.screen_entry_value,
4657: pee.entry_information1
4658: FROM
4659: pay_element_entries_f pee,
4660: pay_element_entry_values_f eev0 ,
4661: pay_element_entry_values_f eev1 ,
4662: pay_element_entry_values_f eev2 ,
4663: pay_element_entry_values_f eev3 ,
4664: pay_element_entry_values_f eev4 ,

Line 4661: pay_element_entry_values_f eev1 ,

4657: pee.entry_information1
4658: FROM
4659: pay_element_entries_f pee,
4660: pay_element_entry_values_f eev0 ,
4661: pay_element_entry_values_f eev1 ,
4662: pay_element_entry_values_f eev2 ,
4663: pay_element_entry_values_f eev3 ,
4664: pay_element_entry_values_f eev4 ,
4665: pay_element_entry_values_f eev5 ,

Line 4662: pay_element_entry_values_f eev2 ,

4658: FROM
4659: pay_element_entries_f pee,
4660: pay_element_entry_values_f eev0 ,
4661: pay_element_entry_values_f eev1 ,
4662: pay_element_entry_values_f eev2 ,
4663: pay_element_entry_values_f eev3 ,
4664: pay_element_entry_values_f eev4 ,
4665: pay_element_entry_values_f eev5 ,
4666: pay_element_entry_values_f eev6 ,

Line 4663: pay_element_entry_values_f eev3 ,

4659: pay_element_entries_f pee,
4660: pay_element_entry_values_f eev0 ,
4661: pay_element_entry_values_f eev1 ,
4662: pay_element_entry_values_f eev2 ,
4663: pay_element_entry_values_f eev3 ,
4664: pay_element_entry_values_f eev4 ,
4665: pay_element_entry_values_f eev5 ,
4666: pay_element_entry_values_f eev6 ,
4667: pay_element_entry_values_f eev7 ,

Line 4664: pay_element_entry_values_f eev4 ,

4660: pay_element_entry_values_f eev0 ,
4661: pay_element_entry_values_f eev1 ,
4662: pay_element_entry_values_f eev2 ,
4663: pay_element_entry_values_f eev3 ,
4664: pay_element_entry_values_f eev4 ,
4665: pay_element_entry_values_f eev5 ,
4666: pay_element_entry_values_f eev6 ,
4667: pay_element_entry_values_f eev7 ,
4668: pay_element_entry_values_f eev8 ,

Line 4665: pay_element_entry_values_f eev5 ,

4661: pay_element_entry_values_f eev1 ,
4662: pay_element_entry_values_f eev2 ,
4663: pay_element_entry_values_f eev3 ,
4664: pay_element_entry_values_f eev4 ,
4665: pay_element_entry_values_f eev5 ,
4666: pay_element_entry_values_f eev6 ,
4667: pay_element_entry_values_f eev7 ,
4668: pay_element_entry_values_f eev8 ,
4669: pay_element_entry_values_f eev9 ,

Line 4666: pay_element_entry_values_f eev6 ,

4662: pay_element_entry_values_f eev2 ,
4663: pay_element_entry_values_f eev3 ,
4664: pay_element_entry_values_f eev4 ,
4665: pay_element_entry_values_f eev5 ,
4666: pay_element_entry_values_f eev6 ,
4667: pay_element_entry_values_f eev7 ,
4668: pay_element_entry_values_f eev8 ,
4669: pay_element_entry_values_f eev9 ,
4670: pay_element_entry_values_f eev10 ,

Line 4667: pay_element_entry_values_f eev7 ,

4663: pay_element_entry_values_f eev3 ,
4664: pay_element_entry_values_f eev4 ,
4665: pay_element_entry_values_f eev5 ,
4666: pay_element_entry_values_f eev6 ,
4667: pay_element_entry_values_f eev7 ,
4668: pay_element_entry_values_f eev8 ,
4669: pay_element_entry_values_f eev9 ,
4670: pay_element_entry_values_f eev10 ,
4671: pay_element_entry_values_f eev11 ,

Line 4668: pay_element_entry_values_f eev8 ,

4664: pay_element_entry_values_f eev4 ,
4665: pay_element_entry_values_f eev5 ,
4666: pay_element_entry_values_f eev6 ,
4667: pay_element_entry_values_f eev7 ,
4668: pay_element_entry_values_f eev8 ,
4669: pay_element_entry_values_f eev9 ,
4670: pay_element_entry_values_f eev10 ,
4671: pay_element_entry_values_f eev11 ,
4672: pay_element_entry_values_f eev12 ,

Line 4669: pay_element_entry_values_f eev9 ,

4665: pay_element_entry_values_f eev5 ,
4666: pay_element_entry_values_f eev6 ,
4667: pay_element_entry_values_f eev7 ,
4668: pay_element_entry_values_f eev8 ,
4669: pay_element_entry_values_f eev9 ,
4670: pay_element_entry_values_f eev10 ,
4671: pay_element_entry_values_f eev11 ,
4672: pay_element_entry_values_f eev12 ,
4673: pay_element_entry_values_f eev13 ,

Line 4670: pay_element_entry_values_f eev10 ,

4666: pay_element_entry_values_f eev6 ,
4667: pay_element_entry_values_f eev7 ,
4668: pay_element_entry_values_f eev8 ,
4669: pay_element_entry_values_f eev9 ,
4670: pay_element_entry_values_f eev10 ,
4671: pay_element_entry_values_f eev11 ,
4672: pay_element_entry_values_f eev12 ,
4673: pay_element_entry_values_f eev13 ,
4674: pay_element_entry_values_f eev14

Line 4671: pay_element_entry_values_f eev11 ,

4667: pay_element_entry_values_f eev7 ,
4668: pay_element_entry_values_f eev8 ,
4669: pay_element_entry_values_f eev9 ,
4670: pay_element_entry_values_f eev10 ,
4671: pay_element_entry_values_f eev11 ,
4672: pay_element_entry_values_f eev12 ,
4673: pay_element_entry_values_f eev13 ,
4674: pay_element_entry_values_f eev14
4675: WHERE

Line 4672: pay_element_entry_values_f eev12 ,

4668: pay_element_entry_values_f eev8 ,
4669: pay_element_entry_values_f eev9 ,
4670: pay_element_entry_values_f eev10 ,
4671: pay_element_entry_values_f eev11 ,
4672: pay_element_entry_values_f eev12 ,
4673: pay_element_entry_values_f eev13 ,
4674: pay_element_entry_values_f eev14
4675: WHERE
4676: eev0.element_entry_id = pee.element_entry_id

Line 4673: pay_element_entry_values_f eev13 ,

4669: pay_element_entry_values_f eev9 ,
4670: pay_element_entry_values_f eev10 ,
4671: pay_element_entry_values_f eev11 ,
4672: pay_element_entry_values_f eev12 ,
4673: pay_element_entry_values_f eev13 ,
4674: pay_element_entry_values_f eev14
4675: WHERE
4676: eev0.element_entry_id = pee.element_entry_id
4677: and eev0.input_value_id = p_inp_value_id_table(1)

Line 4674: pay_element_entry_values_f eev14

4670: pay_element_entry_values_f eev10 ,
4671: pay_element_entry_values_f eev11 ,
4672: pay_element_entry_values_f eev12 ,
4673: pay_element_entry_values_f eev13 ,
4674: pay_element_entry_values_f eev14
4675: WHERE
4676: eev0.element_entry_id = pee.element_entry_id
4677: and eev0.input_value_id = p_inp_value_id_table(1)
4678: and eev1.element_entry_id = pee.element_entry_id