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

Line 422: g_start_date := fnd_date.canonical_to_date(l_chardate_start);

418:
419: g_payroll_action_id := p_payroll_action_id;
420: get_parameters(p_payroll_action_id,'YR',g_year);
421: get_parameters(p_payroll_action_id,'START_DATE',l_chardate_start);
422: g_start_date := fnd_date.canonical_to_date(l_chardate_start);
423: get_parameters(p_payroll_action_id,'END_DATE',l_chardate_end);
424: g_end_date := fnd_date.canonical_to_date(l_chardate_end);
425: get_parameters(p_payroll_action_id,'BG_ID',g_bg_id);
426: get_parameters(p_payroll_action_id,'XML_REPORT_TAG',l_tag);

Line 424: g_end_date := fnd_date.canonical_to_date(l_chardate_end);

420: get_parameters(p_payroll_action_id,'YR',g_year);
421: get_parameters(p_payroll_action_id,'START_DATE',l_chardate_start);
422: g_start_date := fnd_date.canonical_to_date(l_chardate_start);
423: get_parameters(p_payroll_action_id,'END_DATE',l_chardate_end);
424: g_end_date := fnd_date.canonical_to_date(l_chardate_end);
425: get_parameters(p_payroll_action_id,'BG_ID',g_bg_id);
426: get_parameters(p_payroll_action_id,'XML_REPORT_TAG',l_tag);
427: get_parameters(p_payroll_action_id,'DEST_CHAR_SET',g_char_set);
428:

Line 514: AND g_end_date >= fnd_date.canonical_to_date(hoi.org_information4)

510: AND pet.element_type_id = petl.element_type_id
511: AND petl.language = userenv('LANG')
512: AND hou.date_from <= g_end_date
513: AND NVL(hou.date_to,TO_DATE('4712/12/31','YYYY/MM/DD')) >= g_start_date
514: AND g_end_date >= fnd_date.canonical_to_date(hoi.org_information4)
515: AND g_start_date <= NVL(fnd_date.canonical_to_date(hoi.org_information5),TO_DATE('4712/12/31','YYYY/MM/DD'))
516: AND g_end_date BETWEEN pet.effective_start_date AND pet.effective_end_date
517: AND g_end_date BETWEEN pap.effective_start_date AND pap.effective_end_date
518: UNION

Line 515: AND g_start_date <= NVL(fnd_date.canonical_to_date(hoi.org_information5),TO_DATE('4712/12/31','YYYY/MM/DD'))

511: AND petl.language = userenv('LANG')
512: AND hou.date_from <= g_end_date
513: AND NVL(hou.date_to,TO_DATE('4712/12/31','YYYY/MM/DD')) >= g_start_date
514: AND g_end_date >= fnd_date.canonical_to_date(hoi.org_information4)
515: AND g_start_date <= NVL(fnd_date.canonical_to_date(hoi.org_information5),TO_DATE('4712/12/31','YYYY/MM/DD'))
516: AND g_end_date BETWEEN pet.effective_start_date AND pet.effective_end_date
517: AND g_end_date BETWEEN pap.effective_start_date AND pap.effective_end_date
518: UNION
519: SELECT DISTINCT pap.payroll_name payroll_name,

Line 546: AND g_end_date BETWEEN fnd_date.canonical_to_date(hoi.org_information5) AND NVL(fnd_date.canonical_to_date(hoi.org_information6),TO_DATE('4712/12/31','YYYY/MM/DD'));

542: )
543: AND PBT_TL.balance_type_id = fnd_number.canonical_to_number(hoi.org_information2)
544: AND PBT.balance_type_id = PBT_TL.balance_type_id
545: AND PBT_TL.language = userenv('LANG')
546: AND g_end_date BETWEEN fnd_date.canonical_to_date(hoi.org_information5) AND NVL(fnd_date.canonical_to_date(hoi.org_information6),TO_DATE('4712/12/31','YYYY/MM/DD'));
547:
548:
549: /* Group 3 Individual Payroll Records */
550: -- Group each assignment by payroll

Line 905: AND g_end_date BETWEEN fnd_date.canonical_to_date(hoi.org_information4) AND NVL(fnd_date.canonical_to_date(hoi.org_information5),TO_DATE('4712/12/31','YYYY/MM/DD'))

901: and petl.element_type_id = hoi.org_information3
902: and pet.element_type_id = petl.element_type_id
903: and petl.language = userenv('LANG')
904: AND g_end_date BETWEEN hou.date_from AND NVL(hou.date_to,TO_DATE('4712/12/31','YYYY/MM/DD'))
905: AND g_end_date BETWEEN fnd_date.canonical_to_date(hoi.org_information4) AND NVL(fnd_date.canonical_to_date(hoi.org_information5),TO_DATE('4712/12/31','YYYY/MM/DD'))
906: AND g_end_date BETWEEN pet.effective_start_date AND pet.effective_end_date;
907:
908: -- Archive Other balance details
909: CURSOR csr_arch_balances(p_assignment_id IN NUMBER,

Line 957: AND g_end_date BETWEEN fnd_date.canonical_to_date(hoi.org_information5) AND NVL(fnd_date.canonical_to_date(hoi.org_information6),TO_DATE('4712/12/31','YYYY/MM/DD'));

953: and PBT_TL.balance_type_id = hoi.org_information2
954: and PBT.balance_type_id = PBT_TL.balance_type_id
955: and PBT_TL.language = userenv('LANG')
956: AND g_end_date BETWEEN hou.date_from AND NVL(hou.date_to,TO_DATE('4712/12/31','YYYY/MM/DD'))
957: AND g_end_date BETWEEN fnd_date.canonical_to_date(hoi.org_information5) AND NVL(fnd_date.canonical_to_date(hoi.org_information6),TO_DATE('4712/12/31','YYYY/MM/DD'));
958:
959: -- Archive Statutory balance details
960: CURSOR csr_arch_stat_balances(p_assignment_id IN NUMBER,
961: p_payroll_id IN NUMBER,

Line 997: AND g_end_date BETWEEN fnd_date.canonical_to_date(hoi.org_information5) AND NVL(fnd_date.canonical_to_date(hoi.org_information6),TO_DATE('4712/12/31','YYYY/MM/DD'));

993: and PBT_TL.balance_type_id = hoi.org_information2
994: and PBT.balance_type_id = PBT_TL.balance_type_id
995: and PBT_TL.language = userenv('LANG')
996: AND g_end_date BETWEEN hou.date_from AND NVL(hou.date_to,TO_DATE('4712/12/31','YYYY/MM/DD'))
997: AND g_end_date BETWEEN fnd_date.canonical_to_date(hoi.org_information5) AND NVL(fnd_date.canonical_to_date(hoi.org_information6),TO_DATE('4712/12/31','YYYY/MM/DD'));
998:
999: CURSOR get_lookup_values(p_type IN VARCHAR2, p_code IN VARCHAR2)
1000: IS
1001: select lookup_code,meaning from fnd_lookup_values