APPS.GMF_COPY_ITEM_COST dependencies on HR_ORGANIZATION_INFORMATION

Line 578: FROM gmf_period_statuses gps, hr_organization_information org

574: if(pi_period_code_to is not null) then
575: if(pi_organization_id_to is not null) then
576: SELECT gps.period_id
577: INTO pi_period_id_to
578: FROM gmf_period_statuses gps, hr_organization_information org
579: WHERE gps.PERIOD_CODE = pi_period_code_to
580: AND gps.CALENDAR_CODE = pi_calendar_code_to
581: AND gps.legal_entity_id = org.org_information2
582: AND org.organization_id = pi_organization_id_to

Line 600: FROM gmf_period_statuses gps, hr_organization_information org

596: end if;
597:
598: SELECT gps.period_id
599: INTO pi_period_id_from
600: FROM gmf_period_statuses gps, hr_organization_information org
601: WHERE gps.PERIOD_CODE = pi_period_code_from
602: AND gps.CALENDAR_CODE = pi_calendar_code_from
603: AND gps.legal_entity_id = org.org_information2
604: AND org.organization_id = pi_organization_id_from

Line 743: 'hr_organization_information hoi , mtl_parameters mp ' ||

739: l_sql_org :=
740: 'SELECT ' ||
741: 'hoi.organization_id ' ||
742: 'FROM ' ||
743: 'hr_organization_information hoi , mtl_parameters mp ' ||
744: ' WHERE ' ||
745: 'hoi.org_information2 = :pi_all_org_id '||
746: ' AND hoi.org_information_context = ''Accounting Information'' '||
747: ' AND hoi.organization_id = mp.organization_id '||

Line 783: 'gmf_period_statuses c3, gmf_period_statuses c2, gmf_period_statuses c1, hr_organization_information d ' ||

779: if(pi_organization_id_to is not null) then
780: l_sql_periods := 'SELECT ' ||
781: 'c3.period_id ' ||
782: 'FROM ' ||
783: 'gmf_period_statuses c3, gmf_period_statuses c2, gmf_period_statuses c1, hr_organization_information d ' ||
784: 'WHERE ' ||
785: 'd.organization_id = :pi_organization_id_to AND '||
786: 'd.org_information_context = ''Accounting Information'' AND '||
787: 'c1.calendar_code = :pi_calendar_code_to AND ' ||

Line 2008: FROM gmf_period_statuses gps, hr_organization_information org

2004: if(pi_period_code_to is not null) then
2005: if(pi_organization_id_to is not null) then
2006: SELECT gps.period_id
2007: INTO pi_period_id_to
2008: FROM gmf_period_statuses gps, hr_organization_information org
2009: WHERE gps.PERIOD_CODE = pi_period_code_to
2010: AND gps.CALENDAR_CODE = pi_calendar_code_to
2011: AND gps.legal_entity_id = org.org_information2
2012: AND org.organization_id = pi_organization_id_to

Line 2030: FROM gmf_period_statuses gps, hr_organization_information org

2026: end if;
2027:
2028: SELECT gps.period_id
2029: INTO pi_period_id_from
2030: FROM gmf_period_statuses gps, hr_organization_information org
2031: WHERE gps.PERIOD_CODE = pi_period_code_from
2032: AND gps.CALENDAR_CODE = pi_calendar_code_from
2033: AND gps.legal_entity_id = org.org_information2
2034: and org.organization_id = pi_organization_id_from

Line 2124: 'hr_organization_information hoi , mtl_parameters mp ' ||

2120: l_sql_org_b :=
2121: 'SELECT ' ||
2122: 'hoi.organization_id ' ||
2123: 'FROM ' ||
2124: 'hr_organization_information hoi , mtl_parameters mp ' ||
2125: ' WHERE ' ||
2126: 'hoi.org_information2 = :pi_all_org_id '||
2127: ' AND hoi.org_information_context = ''Accounting Information'' '||
2128: ' AND hoi.organization_id = mp.organization_id '||

Line 2161: 'gmf_period_statuses c3, gmf_period_statuses c2, gmf_period_statuses c1, hr_organization_information d ' ||

2157: if(pi_organization_id_to is not null) then
2158: l_sql_periods_b := 'SELECT ' ||
2159: 'c3.period_id ' ||
2160: 'FROM ' ||
2161: 'gmf_period_statuses c3, gmf_period_statuses c2, gmf_period_statuses c1, hr_organization_information d ' ||
2162: 'WHERE ' ||
2163: 'd.organization_id = :pi_organization_id_to AND '||
2164: 'd.org_information_context = ''Accounting Information'' AND '||
2165: 'c1.calendar_code = :pi_calendar_code_to AND ' ||