APPS.HR_DM_INIT dependencies on HR_DM_GROUPS

Line 357: hr_dm_groups grp, hr_dm_application_groups apg

353:
354: CURSOR csr_select_pi IS
355: SELECT tbg.group_id, tbl.table_name
356: FROM hr_dm_tables tbl, hr_dm_table_groupings tbg,
357: hr_dm_groups grp, hr_dm_application_groups apg
358: WHERE ( (tbl.table_id = tbg.table_id)
359: AND (tbg.group_id = grp.group_id)
360: AND (grp.group_type = 'D')
361: AND (grp.group_id = apg.group_id)

Line 776: FROM hr_dm_groups grp,

772: SELECT tbl.loader_conc_program,
773: tbl.loader_config_file,
774: tbl.loader_application,
775: grp.group_id
776: FROM hr_dm_groups grp,
777: hr_dm_application_groups apg,
778: hr_dm_table_groupings tbg,
779: hr_dm_tables tbl
780: WHERE tbl.table_id = tbg.table_id

Line 950: FROM hr_dm_groups grp,

946: lp.parameter8,
947: lp.parameter9,
948: lp.parameter10,
949: grp.group_id
950: FROM hr_dm_groups grp,
951: hr_dm_application_groups apg,
952: hr_dm_table_groupings tbg,
953: hr_dm_tables tbl,
954: hr_dm_loader_params lp

Line 1209: FROM hr_dm_groups grp, hr_dm_application_groups apg

1205: l_group_text VARCHAR2(240);
1206:
1207: CURSOR csr_select_pi IS
1208: SELECT grp.group_id, grp.description
1209: FROM hr_dm_groups grp, hr_dm_application_groups apg
1210: WHERE ((grp.group_type = 'D')
1211: AND (grp.group_id = apg.group_id)
1212: AND (apg.application_id = r_migration_data.application_id)
1213: AND (apg.migration_type = r_migration_data.migration_type) )

Line 1412: FROM hr_dm_groups grp, hr_dm_application_groups apg

1408: l_batch_txt VARCHAR2(80);
1409:
1410: CURSOR csr_select_pi IS
1411: SELECT grp.group_id, grp.description
1412: FROM hr_dm_groups grp, hr_dm_application_groups apg
1413: WHERE ((grp.group_type = 'D')
1414: AND (grp.group_id = apg.group_id)
1415: AND (apg.application_id = r_migration_data.application_id)
1416: AND (apg.migration_type = r_migration_data.migration_type) )

Line 1583: FROM hr_dm_groups grp,

1579: CURSOR csr_select_pi IS
1580: SELECT tbl.loader_name,
1581: lp.loader_params_id,
1582: grp.group_id
1583: FROM hr_dm_groups grp,
1584: hr_dm_application_groups apg,
1585: hr_dm_table_groupings tbg,
1586: hr_dm_tables tbl,
1587: hr_dm_loader_params lp

Line 1660: hr_dm_groups grp

1656:
1657: CURSOR csr_select_pi IS
1658: SELECT apg.group_id, grp.description
1659: FROM hr_dm_application_groups apg,
1660: hr_dm_groups grp
1661: WHERE ((apg.application_id = r_migration_data.application_id)
1662: AND (apg.migration_type = r_migration_data.migration_type)
1663: AND (apg.group_id = grp.group_id))
1664: ORDER BY apg.group_order DESC;

Line 1772: FROM hr_dm_groups grp,

1768: CURSOR csr_select_pi IS
1769: SELECT tbl.loader_name,
1770: lp.loader_params_id,
1771: grp.group_id
1772: FROM hr_dm_groups grp,
1773: hr_dm_application_groups apg,
1774: hr_dm_table_groupings tbg,
1775: hr_dm_tables tbl,
1776: hr_dm_loader_params lp