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.PER_NL_FDR_ARCHIVE dependencies on HR_GENERAL

Line 357: and p_report_date between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)

353: per_periods_of_service ppos,
354: per_org_structure_versions posv
355:
356: where posv.organization_structure_id=p_org_struct_id
357: and p_report_date between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)
358: and (paa.organization_id in
359: ((SELECT pose.organization_id_child
360: FROM per_org_structure_elements pose
361: WHERE pose.org_structure_version_id = posv.org_structure_version_id

Line 415: and p_report_date between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)

411: per_periods_of_service ppos,
412: per_org_structure_versions posv
413:
414: where posv.organization_structure_id=p_org_struct_id
415: and p_report_date between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)
416: and paa.person_id = p_person_id
417: and paa.primary_flag = 'Y'
418: and past.assignment_status_type_id = paa.assignment_status_type_id
419: and past.per_system_status = 'ACTIVE_ASSIGN'

Line 555: AND p_report_date between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)

551: (SELECT pose.organization_id_parent
552: FROM per_org_structure_elements pose,per_org_structure_versions posv
553: WHERE posv.org_structure_version_id = pose.org_structure_version_id
554: AND posv.organization_structure_id=p_org_struct_id
555: AND p_report_date between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)
556:
557: UNION
558:
559: SELECT pose.organization_id_child

Line 563: AND p_report_date between posv.date_from and nvl(posv.date_to,hr_general.end_of_time))

559: SELECT pose.organization_id_child
560: FROM per_org_structure_elements pose,per_org_structure_versions posv
561: WHERE posv.org_structure_version_id = pose.org_structure_version_id
562: AND posv.organization_structure_id=p_org_struct_id
563: AND p_report_date between posv.date_from and nvl(posv.date_to,hr_general.end_of_time))
564:
565: UNION
566:
567: SELECT 1 FROM hr_organization_units hou2, hr_organization_information hoi2

Line 581: AND p_report_date between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)

577: (SELECT pose.organization_id_parent
578: FROM per_org_structure_elements pose,per_org_structure_versions posv
579: WHERE posv.org_structure_version_id = pose.org_structure_version_id
580: AND posv.organization_structure_id=p_org_struct_id
581: AND p_report_date between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)
582:
583: UNION
584:
585: SELECT pose.organization_id_child

Line 589: AND p_report_date between posv.date_from and nvl(posv.date_to,hr_general.end_of_time))

585: SELECT pose.organization_id_child
586: FROM per_org_structure_elements pose,per_org_structure_versions posv
587: WHERE posv.org_structure_version_id = pose.org_structure_version_id
588: AND posv.organization_structure_id=p_org_struct_id
589: AND p_report_date between posv.date_from and nvl(posv.date_to,hr_general.end_of_time))
590:
591: );
592:
593: EXCEPTION

Line 726: and to_date(p_report_date,'RRRR/MM/DD') between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)

722: per_periods_of_service ppos,
723: per_org_structure_versions posv
724:
725: where posv.organization_structure_id=p_org_struct_id
726: and to_date(p_report_date,'RRRR/MM/DD') between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)
727: and (paa.organization_id in
728: ((SELECT pose.organization_id_child
729: FROM per_org_structure_elements pose
730: WHERE pose.org_structure_version_id = posv.org_structure_version_id

Line 783: and to_date(p_report_date,'RRRR/MM/DD') between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)

779: per_periods_of_service ppos,
780: per_org_structure_versions posv
781:
782: where posv.organization_structure_id=p_org_struct_id
783: and to_date(p_report_date,'RRRR/MM/DD') between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)
784: and pap.person_id between p_start_person_id and p_end_person_id
785: and pap.business_group_id = ppa.business_group_id
786: and ppa.payroll_action_id = p_payroll_action_id
787: and pap.effective_start_date >= to_date('04-07-2006','DD-MM-RRRR')

Line 938: and to_date(p_report_date,'RRRR/MM/DD') between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)

934: hr_organization_information hoi,
935: per_org_structure_versions posv
936:
937: where posv.organization_structure_id=p_org_struct_id
938: and to_date(p_report_date,'RRRR/MM/DD') between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)
939: and paa.assignment_action_id = p_assignment_action_id
940: and pas.assignment_id = paa.assignment_id
941: and past.assignment_status_type_id = pas.assignment_status_type_id
942: and past.per_system_status = 'ACTIVE_ASSIGN'

Line 1318: and to_date(p_report_date,'RRRR/MM/DD') between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)

1314: per_periods_of_service ppos,
1315: per_org_structure_versions posv
1316:
1317: where posv.organization_structure_id=p_org_struct_id
1318: and to_date(p_report_date,'RRRR/MM/DD') between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)
1319: and pap.business_group_id = ppa.business_group_id
1320: and ppa.payroll_action_id = p_payroll_action_id
1321: and pap.effective_start_date >= to_date('04-07-2006','DD-MM-RRRR')
1322: and ppos.business_group_id = pap.business_group_id

Line 1390: l_head_length := length(hr_general.decode_lookup('NL_FDR_LABELS','REP_HEAD'));

1386: END LOOP;
1387:
1388: END IF;
1389:
1390: l_head_length := length(hr_general.decode_lookup('NL_FDR_LABELS','REP_HEAD'));
1391:
1392: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(hr_general.decode_lookup('NL_FDR_LABELS','REP_HEAD'),((123-l_head_length)/2)+l_head_length,' '));
1393: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1394: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(rpad(' ',l_head_length+1,'-'),((123-l_head_length)/2)+l_head_length,' '));

Line 1392: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(hr_general.decode_lookup('NL_FDR_LABELS','REP_HEAD'),((123-l_head_length)/2)+l_head_length,' '));

1388: END IF;
1389:
1390: l_head_length := length(hr_general.decode_lookup('NL_FDR_LABELS','REP_HEAD'));
1391:
1392: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(hr_general.decode_lookup('NL_FDR_LABELS','REP_HEAD'),((123-l_head_length)/2)+l_head_length,' '));
1393: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1394: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(rpad(' ',l_head_length+1,'-'),((123-l_head_length)/2)+l_head_length,' '));
1395: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);
1396: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BG_NAME'),30,' '));

Line 1396: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BG_NAME'),30,' '));

1392: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(hr_general.decode_lookup('NL_FDR_LABELS','REP_HEAD'),((123-l_head_length)/2)+l_head_length,' '));
1393: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1394: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(rpad(' ',l_head_length+1,'-'),((123-l_head_length)/2)+l_head_length,' '));
1395: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);
1396: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BG_NAME'),30,' '));
1397: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1398: FND_FILE.PUT(FND_FILE.OUTPUT, l_bg_name);
1399: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1400: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','REP_DATE'),30,' '));

Line 1400: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','REP_DATE'),30,' '));

1396: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BG_NAME'),30,' '));
1397: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1398: FND_FILE.PUT(FND_FILE.OUTPUT, l_bg_name);
1399: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1400: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','REP_DATE'),30,' '));
1401: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1402: FND_FILE.PUT(FND_FILE.OUTPUT, fnd_date.date_to_displaydate(to_date(l_report_date, 'RRRR/MM/DD HH24:MI:SS')));
1403: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 6);
1404:

Line 1418: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMPLOYER'),30,' '));

1414:
1415: END IF;
1416:
1417:
1418: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMPLOYER'),30,' '));
1419: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1420: FND_FILE.PUT(FND_FILE.OUTPUT, v_csr_get_employer.org_name);
1421: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1422: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'),30,' '));

Line 1422: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'),30,' '));

1418: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMPLOYER'),30,' '));
1419: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1420: FND_FILE.PUT(FND_FILE.OUTPUT, v_csr_get_employer.org_name);
1421: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1422: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'),30,' '));
1423: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1424: FND_FILE.PUT(FND_FILE.OUTPUT, v_csr_get_employer.tax_reg_num);
1425: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
1426:

Line 1429: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NO'), 21, ' '));

1425: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
1426:
1427: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(' ',123,'-'));
1428: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1429: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NO'), 21, ' '));
1430: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NAME'), 40, ' '));
1431: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','SOFI_NO'), 20, ' '));
1432: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'), 30, ' '));
1433: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','HIRE_DATE'), 21, ' '));

Line 1430: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NAME'), 40, ' '));

1426:
1427: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(' ',123,'-'));
1428: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1429: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NO'), 21, ' '));
1430: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NAME'), 40, ' '));
1431: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','SOFI_NO'), 20, ' '));
1432: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'), 30, ' '));
1433: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','HIRE_DATE'), 21, ' '));
1434: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BIRTH_DATE'), 21, ' '));

Line 1431: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','SOFI_NO'), 20, ' '));

1427: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(' ',123,'-'));
1428: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1429: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NO'), 21, ' '));
1430: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NAME'), 40, ' '));
1431: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','SOFI_NO'), 20, ' '));
1432: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'), 30, ' '));
1433: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','HIRE_DATE'), 21, ' '));
1434: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BIRTH_DATE'), 21, ' '));
1435: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

Line 1432: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'), 30, ' '));

1428: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1429: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NO'), 21, ' '));
1430: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NAME'), 40, ' '));
1431: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','SOFI_NO'), 20, ' '));
1432: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'), 30, ' '));
1433: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','HIRE_DATE'), 21, ' '));
1434: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BIRTH_DATE'), 21, ' '));
1435: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1436: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(' ',123,'-'));

Line 1433: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','HIRE_DATE'), 21, ' '));

1429: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NO'), 21, ' '));
1430: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NAME'), 40, ' '));
1431: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','SOFI_NO'), 20, ' '));
1432: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'), 30, ' '));
1433: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','HIRE_DATE'), 21, ' '));
1434: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BIRTH_DATE'), 21, ' '));
1435: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1436: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(' ',123,'-'));
1437: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

Line 1434: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BIRTH_DATE'), 21, ' '));

1430: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NAME'), 40, ' '));
1431: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','SOFI_NO'), 20, ' '));
1432: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'), 30, ' '));
1433: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','HIRE_DATE'), 21, ' '));
1434: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BIRTH_DATE'), 21, ' '));
1435: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1436: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(' ',123,'-'));
1437: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1438: