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_SE_WAGES_SALARIES dependencies on FND_DATE

Line 152: ,FND_DATE.canonical_to_date((get_parameter

148: (legislative_parameters
149: , 'YEAR'
150: )
151: ) L_YEAR
152: ,FND_DATE.canonical_to_date((get_parameter
153: (legislative_parameters
154: , 'RETROACTIVE_PAYMENT_FROM'
155: )
156: )) L_RETROACTIVE_PAYMENT_FROM

Line 157: ,FND_DATE.canonical_to_date((get_parameter

153: (legislative_parameters
154: , 'RETROACTIVE_PAYMENT_FROM'
155: )
156: )) L_RETROACTIVE_PAYMENT_FROM
157: ,FND_DATE.canonical_to_date((get_parameter
158: (legislative_parameters
159: , 'RETROACTIVE_PAYMENT_TO'
160: )
161: )) L_RETROACTIVE_PAYMENT_TO

Line 424: SELECT greatest(fnd_Date.canonical_to_date(eev1.screen_entry_value),csr_v_start_date) start_date,

420: ORDER BY paaf.assignment_id;
421:
422: CURSOR csr_assignment_absence (csr_v_assignment_id number, csr_v_start_date date, csr_v_end_date date)
423: is
424: SELECT greatest(fnd_Date.canonical_to_date(eev1.screen_entry_value),csr_v_start_date) start_date,
425: least(fnd_Date.canonical_to_date(eev2.screen_entry_value),csr_v_end_date) end_date
426: FROM per_all_assignments_f asg1
427: ,per_all_assignments_f asg2
428: ,per_all_people_f per

Line 425: least(fnd_Date.canonical_to_date(eev2.screen_entry_value),csr_v_end_date) end_date

421:
422: CURSOR csr_assignment_absence (csr_v_assignment_id number, csr_v_start_date date, csr_v_end_date date)
423: is
424: SELECT greatest(fnd_Date.canonical_to_date(eev1.screen_entry_value),csr_v_start_date) start_date,
425: least(fnd_Date.canonical_to_date(eev2.screen_entry_value),csr_v_end_date) end_date
426: FROM per_all_assignments_f asg1
427: ,per_all_assignments_f asg2
428: ,per_all_people_f per
429: ,pay_element_links_f el

Line 707: , p_action_information9 => FND_DATE.DATE_TO_CANONICAL(g_retroactive_payment_from)

703: , p_action_information5 => g_local_unit_id
704: , p_action_information6 => L_LOCAL_UNIT_NAME
705: , p_action_information7 => l_month --TO_CHAR(TO_DATE(g_month,'MM'),'MONTH')
706: , p_action_information8 => g_year
707: , p_action_information9 => FND_DATE.DATE_TO_CANONICAL(g_retroactive_payment_from)
708: , p_action_information10 => FND_DATE.DATE_TO_CANONICAL(g_retroactive_payment_to)
709: );
710: -- *****************************************************************************
711:

Line 708: , p_action_information10 => FND_DATE.DATE_TO_CANONICAL(g_retroactive_payment_to)

704: , p_action_information6 => L_LOCAL_UNIT_NAME
705: , p_action_information7 => l_month --TO_CHAR(TO_DATE(g_month,'MM'),'MONTH')
706: , p_action_information8 => g_year
707: , p_action_information9 => FND_DATE.DATE_TO_CANONICAL(g_retroactive_payment_from)
708: , p_action_information10 => FND_DATE.DATE_TO_CANONICAL(g_retroactive_payment_to)
709: );
710: -- *****************************************************************************
711:
712:

Line 962: SELECT greatest(fnd_Date.canonical_to_date(eev1.screen_entry_value),csr_v_start_date) start_date,

958: ORDER BY paaf.assignment_id;
959:
960: CURSOR csr_assignment_absence (csr_v_assignment_id number, csr_v_start_date date, csr_v_end_date date)
961: is
962: SELECT greatest(fnd_Date.canonical_to_date(eev1.screen_entry_value),csr_v_start_date) start_date,
963: least(fnd_Date.canonical_to_date(eev2.screen_entry_value),csr_v_end_date) end_date
964: FROM per_all_assignments_f asg1
965: ,per_all_assignments_f asg2
966: ,per_all_people_f per

Line 963: least(fnd_Date.canonical_to_date(eev2.screen_entry_value),csr_v_end_date) end_date

959:
960: CURSOR csr_assignment_absence (csr_v_assignment_id number, csr_v_start_date date, csr_v_end_date date)
961: is
962: SELECT greatest(fnd_Date.canonical_to_date(eev1.screen_entry_value),csr_v_start_date) start_date,
963: least(fnd_Date.canonical_to_date(eev2.screen_entry_value),csr_v_end_date) end_date
964: FROM per_all_assignments_f asg1
965: ,per_all_assignments_f asg2
966: ,per_all_people_f per
967: ,pay_element_links_f el

Line 3770: fnd_date.canonical_to_date(pai.action_information9) retroactive_date_from,

3766: SELECT pai.action_information3 legal_employer,
3767: pai1.action_information4 local_unit,
3768: pai.action_information7 month,
3769: pai.action_information8 year,
3770: fnd_date.canonical_to_date(pai.action_information9) retroactive_date_from,
3771: fnd_date.canonical_to_date(pai.action_information10) retroactive_date_to,
3772: decode(pai2.action_information4,0,NULL,pai2.action_information4) bh_worked_calendar_month,
3773: decode(pai2.action_information5,0,NULL,pai2.action_information5) bh_worked_payment_period,
3774: decode(pai2.action_information12,0,NULL,pai2.action_information12) bh_pbt_value,

Line 3771: fnd_date.canonical_to_date(pai.action_information10) retroactive_date_to,

3767: pai1.action_information4 local_unit,
3768: pai.action_information7 month,
3769: pai.action_information8 year,
3770: fnd_date.canonical_to_date(pai.action_information9) retroactive_date_from,
3771: fnd_date.canonical_to_date(pai.action_information10) retroactive_date_to,
3772: decode(pai2.action_information4,0,NULL,pai2.action_information4) bh_worked_calendar_month,
3773: decode(pai2.action_information5,0,NULL,pai2.action_information5) bh_worked_payment_period,
3774: decode(pai2.action_information12,0,NULL,pai2.action_information12) bh_pbt_value,
3775: decode(pai2.action_information13,0,NULL,pai2.action_information13) bh_pcow_value,

Line 3864: fnd_date.canonical_to_date(pai.action_information9) retroactive_date_from,

3860: SELECT pai.action_information3 legal_employer,
3861: pai1.action_information4 local_unit,
3862: pai.action_information7 || ' ' || pai.action_information8 period,-- month,
3863: --pai.action_information8 year,
3864: fnd_date.canonical_to_date(pai.action_information9) retroactive_date_from,
3865: fnd_date.canonical_to_date(pai.action_information10) retroactive_date_to
3866: FROM
3867: pay_action_information pai,
3868: pay_action_information pai1,

Line 3865: fnd_date.canonical_to_date(pai.action_information10) retroactive_date_to

3861: pai1.action_information4 local_unit,
3862: pai.action_information7 || ' ' || pai.action_information8 period,-- month,
3863: --pai.action_information8 year,
3864: fnd_date.canonical_to_date(pai.action_information9) retroactive_date_from,
3865: fnd_date.canonical_to_date(pai.action_information10) retroactive_date_to
3866: FROM
3867: pay_action_information pai,
3868: pay_action_information pai1,
3869: pay_payroll_actions ppa