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.JA_CN_PS_HRMS_EXPORT_PKG dependencies on FND_PROFILE

Line 343: AND business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')

339: analysis_criteria_id
340: FROM
341: per_person_analyses
342: WHERE person_id = pn_person_id
343: AND business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
344: AND pd_date BETWEEN date_from AND nvl(date_to,to_date('31-12-4712','dd-mm-yyyy'))
345: AND id_flex_num = (SELECT id_flex_num
346: FROM fnd_id_flex_structures_vl
347: WHERE id_flex_code='PEA'

Line 416: AND business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')

412: analysis_criteria_id
413: FROM
414: per_person_analyses
415: WHERE person_id = pn_person_id
416: AND business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
417: AND pd_date BETWEEN date_from AND nvl(date_to,to_date('31-12-4712','dd-mm-yyyy'))
418: AND id_flex_num = (SELECT id_flex_num
419: FROM fnd_id_flex_structures_vl
420: WHERE id_flex_code='PEA'

Line 515: AND org.business_group_id = fnd_profile.VALUE('PER_BUSINESS_GROUP_ID')

511: hr_organization_units org
512: , hr_all_organization_units_tl orgtl
513: WHERE orgtl.organization_id = org.organization_id
514: AND orgtl.LANGUAGE = userenv('LANG')
515: AND org.business_group_id = fnd_profile.VALUE('PER_BUSINESS_GROUP_ID')
516: AND date_from <= ld_acc_end_date
517: AND nvl( date_to, ld_acc_end_date) >= ld_acc_start_date
518: AND EXISTS (SELECT 1
519: FROM hr_organization_information info

Line 736: AND ppf.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')

732: FROM per_periods_of_service ppos
733: WHERE ppos.person_id = ppf.person_id)
734: )
735:
736: AND ppf.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
737: AND paf.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
738:
739: BEGIN
740: --logging for debug

Line 737: AND paf.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');

733: WHERE ppos.person_id = ppf.person_id)
734: )
735:
736: AND ppf.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
737: AND paf.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
738:
739: BEGIN
740: --logging for debug
741: IF (ln_proc_level >= ln_dbg_level)

Line 987: WHERE paf.business_group_id = FND_PROFILE.value('PER_BUSINESS_GROUP_ID')

983: --bug#10120576 added the DISTINCT
984: DISTINCT paf.employee_category employee_category
985: FROM
986: per_assignments_f paf
987: WHERE paf.business_group_id = FND_PROFILE.value('PER_BUSINESS_GROUP_ID')
988: AND ld_acc_end_date
989: BETWEEN paf.effective_start_date AND paf.effective_end_date
990: AND EXISTS (SELECT
991: 1

Line 997: AND paf.business_group_id = FND_PROFILE.value('PER_BUSINESS_GROUP_ID')

993: hr_organization_units hou
994: , hr_soft_coding_keyflex scl
995: WHERE paf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
996: AND scl.segment1 = hou.organization_id
997: AND paf.business_group_id = FND_PROFILE.value('PER_BUSINESS_GROUP_ID')
998: )
999: AND paf.employee_category IS NOT NULL;
1000: CURSOR acc_date_cur IS
1001: SELECT