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_ENTRIES_F

Line 302: pay_element_entries_f pee,

298: IS
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

Line 376: pay_element_entries_f pee,

372: IS
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

Line 1429: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

1425:
1426:
1427: function check_if_retro
1428: (
1429: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1430: p_date_earned in pay_payroll_actions.date_earned%TYPE
1431:
1432: )return varchar2 is
1433:

Line 1435: l_creator_type pay_element_entries_f.creator_type%TYPE;

1431:
1432: )return varchar2 is
1433:
1434:
1435: l_creator_type pay_element_entries_f.creator_type%TYPE;
1436: IS_retro_payment varchar2(10);
1437: l_procedure varchar2(80);
1438: begin
1439: g_debug := hr_utility.debug_enabled;

Line 1475: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

1471:
1472:
1473: function get_retro_period
1474: (
1475: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1476: p_date_earned in pay_payroll_actions.date_earned%TYPE,
1477: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,/*Bug 4418107*/
1478: p_retro_start_date out NOCOPY date,
1479: p_retro_end_date out NOCOPY date

Line 1484: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

1480: )return number is
1481:
1482:
1483: cursor get_retro_period_rr
1484: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1485: c_date_earned in pay_payroll_actions.date_earned%TYPE
1486: ) is
1487: SELECT ptp.start_date,ptp.end_date
1488: FROM per_time_periods ptp,

Line 1492: pay_element_entries_f pee

1488: FROM per_time_periods ptp,
1489: pay_payroll_actions ppa,
1490: pay_assignment_actions paa,
1491: pay_run_results prr,
1492: pay_element_entries_f pee
1493: WHERE pee.element_entry_id=c_element_entry_id
1494: and prr.run_result_id = pee.source_id
1495: and paa.assignment_action_id=prr.assignment_action_id
1496: AND paa.tax_unit_id = p_tax_unit_id /*Bug 4418107*/

Line 1506: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

1502:
1503:
1504:
1505: cursor get_retro_period_ee
1506: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1507: c_date_earned in pay_payroll_actions.date_earned%TYPE
1508: ) is
1509: SELECT ptp.start_date,ptp.end_date
1510: FROM per_time_periods ptp,

Line 1513: pay_element_entries_f pee

1509: SELECT ptp.start_date,ptp.end_date
1510: FROM per_time_periods ptp,
1511: pay_payroll_actions ppa,
1512: pay_assignment_actions paa,
1513: pay_element_entries_f pee
1514: WHERE pee.element_entry_id=c_element_entry_id
1515: and paa.assignment_action_id=pee.source_asg_action_id
1516: AND paa.tax_unit_id = p_tax_unit_id /*Bug 4418107*/
1517: and ppa.payroll_action_id=paa.payroll_action_id

Line 1523: l_creator_type pay_element_entries_f.creator_type%TYPE;

1519: and pee.creator_type='EE'
1520: and ppa.date_earned between ptp.start_date and ptp.end_date
1521: and c_date_earned between pee.effective_start_date and pee.effective_end_date;
1522:
1523: l_creator_type pay_element_entries_f.creator_type%TYPE;
1524: l_period_obtained_flag number;
1525: l_procedure varchar2(80);
1526:
1527:

Line 1598: p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE,

1594: */
1595:
1596: FUNCTION get_enhanced_retro_period
1597: (
1598: p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE,
1599: p_date_earned IN pay_payroll_actions.date_earned%TYPE,
1600: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
1601: p_retro_start_date OUT NOCOPY date,
1602: p_retro_end_date OUT NOCOPY date,

Line 1613: (c_element_entry_id pay_element_entries_f.element_entry_id%TYPE)

1609: /* Bug 5586445 - Cursor get_retropay_run_details
1610: Get Effective Date of the Enhanced Retropay process
1611: */
1612: CURSOR get_retropay_run_details
1613: (c_element_entry_id pay_element_entries_f.element_entry_id%TYPE)
1614: IS
1615: SELECT pee.creator_type,
1616: ppa.effective_date
1617: FROM pay_payroll_actions ppa,

Line 1619: pay_element_entries_f pee

1615: SELECT pee.creator_type,
1616: ppa.effective_date
1617: FROM pay_payroll_actions ppa,
1618: pay_assignment_actions paa,
1619: pay_element_entries_f pee
1620: WHERE ppa.payroll_action_id = paa.payroll_action_id
1621: AND paa.assignment_action_id = pee.creator_id
1622: AND pee.element_entry_id = c_element_entry_id
1623: AND ppa.action_type ='L';

Line 1626: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

1622: AND pee.element_entry_id = c_element_entry_id
1623: AND ppa.action_type ='L';
1624:
1625: CURSOR get_retro_period_rr
1626: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1627: c_date_earned in pay_payroll_actions.date_earned%TYPE
1628: )
1629: IS
1630: SELECT ptp.start_date

Line 1637: pay_element_entries_f pee

1633: FROM per_time_periods ptp,
1634: pay_payroll_actions ppa,
1635: pay_assignment_actions paa,
1636: pay_run_results prr,
1637: pay_element_entries_f pee
1638: WHERE pee.element_entry_id=c_element_entry_id
1639: AND prr.run_result_id = pee.source_id
1640: AND paa.assignment_action_id=prr.assignment_action_id
1641: AND paa.tax_unit_id = p_tax_unit_id

Line 1650: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

1646: AND c_date_earned between pee.effective_start_date and pee.effective_end_date;
1647:
1648:
1649: CURSOR get_retro_period_ee
1650: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1651: c_date_earned in pay_payroll_actions.date_earned%TYPE
1652: )
1653: IS
1654: SELECT ptp.start_date

Line 1660: pay_element_entries_f pee

1656: ,ppa.effective_date
1657: FROM per_time_periods ptp,
1658: pay_payroll_actions ppa,
1659: pay_assignment_actions paa,
1660: pay_element_entries_f pee
1661: WHERE pee.element_entry_id=c_element_entry_id
1662: AND paa.assignment_action_id=pee.source_asg_action_id
1663: AND paa.tax_unit_id = p_tax_unit_id
1664: AND ppa.payroll_action_id=paa.payroll_action_id

Line 1673: l_creator_type pay_element_entries_f.creator_type%TYPE;

1669:
1670: l_period_obtained_flag number;
1671:
1672: l_procedure VARCHAR2(80);
1673: l_creator_type pay_element_entries_f.creator_type%TYPE;
1674: l_fin_year_start DATE;
1675: l_month_start DATE;
1676: l_orig_month_start DATE;
1677: l_time_span VARCHAR2(80);

Line 1828: p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE,

1824:
1825:
1826: FUNCTION get_retro_time_span
1827: (
1828: p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE,
1829: p_date_earned IN pay_payroll_actions.date_earned%TYPE,
1830: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
1831: p_retro_start_date OUT NOCOPY date,
1832: p_retro_end_date OUT NOCOPY date,

Line 1841: (c_element_entry_id pay_element_entries_f.element_entry_id%TYPE

1837: )RETURN NUMBER
1838: IS
1839:
1840: CURSOR get_retro_entry_details
1841: (c_element_entry_id pay_element_entries_f.element_entry_id%TYPE
1842: ,c_date_earned pay_payroll_actions.date_earned%TYPE)
1843: IS
1844: SELECT pee.element_entry_id
1845: ,ppa.retro_definition_id

Line 1847: FROM pay_element_entries_f pee

1843: IS
1844: SELECT pee.element_entry_id
1845: ,ppa.retro_definition_id
1846: ,pepd.retro_component_id
1847: FROM pay_element_entries_f pee
1848: ,pay_assignment_actions paa
1849: ,pay_payroll_actions ppa
1850: ,pay_entry_process_details pepd
1851: WHERE pee.element_entry_id = c_element_entry_id

Line 1971: select pee.element_entry_id from pay_element_entries_f pee,

1967: -- Need to get the pay value amount so we can check totals in each period.
1968: /*
1969: cursor get_element_entries
1970: is
1971: select pee.element_entry_id from pay_element_entries_f pee,
1972: pay_assignment_actions paa
1973: where paa.assignment_action_id=p_assignment_action_id
1974: and pee.assignment_id=paa.assignment_id
1975: and pee.creator_type IN ('EE','RR')

Line 1983: from pay_element_entries_f pee,

1979: is
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,

Line 2288: from pay_element_entries_f pee,

2284: select pee.element_entry_id,
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,

Line 2324: from pay_element_entries_f pee,

2320: is
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,

Line 2359: from pay_element_entries_f pee,

2355: is
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,

Line 2856: pay_element_entries_f peef, /* Bug#2563515 */

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
2859: where pet.element_name = 'Extra Withholding Payments'
2860: and pet.element_type_id= piv.element_type_id

Line 3055: p_element_type_id in pay_element_entries_f.element_entry_id%TYPE,

3051: */
3052: FUNCTION get_salary_basis_hours
3053: (
3054: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
3055: p_element_type_id in pay_element_entries_f.element_entry_id%TYPE,
3056: p_pay_bases_id in per_all_assignments_f.pay_basis_id%TYPE
3057: )
3058: RETURN NUMBER IS
3059:

Line 3060: l_element_type_id pay_element_entries_f.element_entry_id%TYPE;

3056: p_pay_bases_id in per_all_assignments_f.pay_basis_id%TYPE
3057: )
3058: RETURN NUMBER IS
3059:
3060: l_element_type_id pay_element_entries_f.element_entry_id%TYPE;
3061: l_result number := NULL;
3062: l_procedure varchar2(80);
3063:
3064: CURSOR Cr_value IS (

Line 3254: pay_element_entries_f pee

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
3256: and prr.RUN_RESULT_ID = prv.RUN_RESULT_ID
3257: and prv.input_value_id = piv.input_value_id
3258: and piv.name ='Periods Spread Over'

Line 3290: pay_element_entries_f pee

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
3292: and prr.RUN_RESULT_ID = prv.RUN_RESULT_ID
3293: and prv.input_value_id = piv.input_value_id
3294: and piv.name ='Total Payment'

Line 3402: pay_element_entries_f pee

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
3404: and prr.RUN_RESULT_ID = prv.RUN_RESULT_ID
3405: and prv.input_value_id = piv.input_value_id
3406: and piv.name ='Total Payment'

Line 3459: pay_element_entries_f pee,

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

Line 3717: FROM pay_element_entries_f pee,

3713: IS
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,

Line 3745: (c_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

3741: AND piv.name = 'Pay Value';
3742:
3743:
3744: CURSOR get_spread_over_ee
3745: (c_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
3746: ,c_assignment_id IN pay_assignment_actions.assignment_id%TYPE
3747: ,c_date_earned IN DATE )
3748: IS
3749: SELECT peev.screen_entry_value

Line 3750: FROM pay_element_entries_f pee

3746: ,c_assignment_id IN pay_assignment_actions.assignment_id%TYPE
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

Line 3765: (c_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

3761: AND c_date_earned BETWEEN peev.effective_start_date AND peev.effective_end_date
3762: AND c_date_earned BETWEEN pivf.effective_start_date AND pivf.effective_end_date;
3763:
3764: CURSOR get_spread_over_rr
3765: (c_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
3766: ,c_assignment_id IN pay_assignment_actions.assignment_id%TYPE
3767: ,c_date_earned IN DATE )
3768: IS
3769: SELECT prrv.result_value

Line 3773: ,pay_element_entries_f pee

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'
3777: AND prr.run_result_id = pee.source_id

Line 4532: l_entry_information pay_element_entries_f.entry_information1%type;

4528: g_date DATE := to_date('01-07-2012','dd-mm-yyyy');
4529: l_new_value varchar2(60);
4530: l_object_version_number NUMBER := -1;
4531: l_full_name VARCHAR2(100);
4532: l_entry_information pay_element_entries_f.entry_information1%type;
4533: l_count NUMBER := 0;
4534: l_asg_exist NUMBER := 0;
4535: l_upgraded NUMBER := 0;
4536: l_emp_num per_all_people_f.employee_number%TYPE;

Line 4574: from pay_element_entries_f pee

4570: ,pee.element_entry_id
4571: ,pee.effective_start_date
4572: ,pee.effective_end_date
4573: ,pee.object_version_number
4574: from pay_element_entries_f pee
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 (

Line 4589: from pay_element_entries_f pee

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
4592: and pee.effective_start_date = g_date
4593: and exists (

Line 4603: pay_element_entries_f pee1

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
4607: and pee1.element_entry_id = pee.element_entry_id

Line 4616: from pay_element_entries_f pee

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
4619: and exists (
4620: select 1 from pay_element_entry_values_f peev

Line 4626: and exists ( select 1 from pay_element_entries_f pee1

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
4625: )
4626: and exists ( select 1 from pay_element_entries_f pee1
4627: where pee1.element_type_id = p_element_type_id
4628: and pee1.assignment_id = pee.assignment_id
4629: and pee1.element_entry_id = pee.element_entry_id
4630: and ( pee1.effective_start_date > pee.effective_start_date

Line 4659: pay_element_entries_f pee,

4655: eev13.screen_entry_value,
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 ,

Line 4801: from pay_element_entries_f

4797:
4798: -- cursor for first record of element entry
4799: cursor fut_fir_ele_rec(p_element_entry_id IN NUMBER) IS
4800: select assignment_id,element_entry_id,effective_start_date,effective_end_date,object_version_number
4801: from pay_element_entries_f
4802: where element_entry_id = p_element_entry_id
4803: and g_date between effective_start_date and effective_end_date;
4804:
4805: -- cursor for future records of element entry post 01-jul-2012

Line 4808: from pay_element_entries_f

4804:
4805: -- cursor for future records of element entry post 01-jul-2012
4806: cursor fut_all_next_ele_rec(p_element_entry_id IN NUMBER) IS
4807: select assignment_id,element_entry_id,effective_start_date,effective_end_date,object_version_number
4808: from pay_element_entries_f
4809: where element_entry_id = p_element_entry_id
4810: and effective_start_date > g_date;
4811:
4812: -- cursor for number of future records of element entries post 01-jul-2012

Line 4815: from pay_element_entries_f

4811:
4812: -- cursor for number of future records of element entries post 01-jul-2012
4813: cursor cnt_fut_ele_rec(p_element_entry_id IN NUMBER) IS
4814: select count(*)
4815: from pay_element_entries_f
4816: where element_entry_id = p_element_entry_id
4817: and effective_start_date > g_date;
4818:
4819: BEGIN