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_RI_CRP_DEFAULT_SETTINGS dependencies on PER_BUSINESS_GROUPS

Line 442: FROM PAY_CONSOLIDATION_SETS c,PER_BUSINESS_GROUPS b

438:
439: -- Declare a Cursor to capture the consolidation set
440: CURSOR csr_consolidation_set_id IS
441: SELECT c.consolidation_set_id
442: FROM PAY_CONSOLIDATION_SETS c,PER_BUSINESS_GROUPS b
443: WHERE b.business_group_id = p_bg_id
444: AND b.business_group_id = c.business_group_id
445: AND c.consolidation_set_name = p_consolidation_set_name;
446:

Line 999: l_bg_name PER_BUSINESS_GROUPS.NAME%TYPE := null;

995: l_retcode NUMBER := null;
996: l_errbuff VARCHAR2(200) := null;
997: l_bg_id NUMBER := null;
998: l_bg_start_date DATE := null;
999: l_bg_name PER_BUSINESS_GROUPS.NAME%TYPE := null;
1000: l_org_id NUMBER := null;
1001: l_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE := null;
1002: l_leg_code VARCHAR2(2) := null;
1003: l_short_code VARCHAR2(9) := null;

Line 1019: FROM PER_BUSINESS_GROUPS

1015: -- the last AND clause to apply to all US and UK BG's, during
1016: -- actual implementation
1017: CURSOR csr_business_group_info(p_bg_id NUMBER) IS
1018: SELECT business_group_id,date_from,name,legislation_code
1019: FROM PER_BUSINESS_GROUPS
1020: WHERE business_group_id is not null
1021: and business_group_id = p_bg_id;
1022:
1023: -- Declare cursor to capture the Organization ID from Business Group ID and Name