DBA Data[Home] [Help]

APPS.HR_FR_SEED_PKG dependencies on DUAL

Line 213: FROM dual;

209: IF user_row_id_csr%NOTFOUND THEN
210: --
211: SELECT pay_user_rows_s.nextval
212: INTO v_user_row_id
213: FROM dual;
214:
215: -- this insertion creates the row
216:
217: hr_utility.trace ('Inserting row '||P_ROW_LOW_RANGE_OR_NAME_CR);

Line 1736: ,p_name => 'INDIVIDUAL_WORK_PATTERN'

1732: --
1733: hr_summary_api.CREATE_ITEM_TYPE (p_item_type_id => l_id_value
1734: ,p_business_group_id => p_business_group_id
1735: ,p_object_version_number => l_object_version_number
1736: ,p_name => 'INDIVIDUAL_WORK_PATTERN'
1737: ,p_units => 'HEADCOUNT'
1738: ,p_datatype => 'N'
1739: ,p_count_clause1 => 'count(distinct(p.person_id))'
1740: ,p_seeded_data => 'Y'

Line 1808: , (select ''01'' month from sys.dual

1804: , per_all_people_f p
1805: , per_assignment_status_types per_ast
1806: , per_all_assignments_f a
1807: , P_ESTABLISHMENT_TABLE
1808: , (select ''01'' month from sys.dual
1809: union select ''02'' month from sys.dual
1810: union select ''03'' month from sys.dual
1811: union select ''04'' month from sys.dual
1812: union select ''05'' month from sys.dual

Line 1809: union select ''02'' month from sys.dual

1805: , per_assignment_status_types per_ast
1806: , per_all_assignments_f a
1807: , P_ESTABLISHMENT_TABLE
1808: , (select ''01'' month from sys.dual
1809: union select ''02'' month from sys.dual
1810: union select ''03'' month from sys.dual
1811: union select ''04'' month from sys.dual
1812: union select ''05'' month from sys.dual
1813: union select ''06'' month from sys.dual

Line 1810: union select ''03'' month from sys.dual

1806: , per_all_assignments_f a
1807: , P_ESTABLISHMENT_TABLE
1808: , (select ''01'' month from sys.dual
1809: union select ''02'' month from sys.dual
1810: union select ''03'' month from sys.dual
1811: union select ''04'' month from sys.dual
1812: union select ''05'' month from sys.dual
1813: union select ''06'' month from sys.dual
1814: union select ''07'' month from sys.dual

Line 1811: union select ''04'' month from sys.dual

1807: , P_ESTABLISHMENT_TABLE
1808: , (select ''01'' month from sys.dual
1809: union select ''02'' month from sys.dual
1810: union select ''03'' month from sys.dual
1811: union select ''04'' month from sys.dual
1812: union select ''05'' month from sys.dual
1813: union select ''06'' month from sys.dual
1814: union select ''07'' month from sys.dual
1815: union select ''08'' month from sys.dual

Line 1812: union select ''05'' month from sys.dual

1808: , (select ''01'' month from sys.dual
1809: union select ''02'' month from sys.dual
1810: union select ''03'' month from sys.dual
1811: union select ''04'' month from sys.dual
1812: union select ''05'' month from sys.dual
1813: union select ''06'' month from sys.dual
1814: union select ''07'' month from sys.dual
1815: union select ''08'' month from sys.dual
1816: union select ''09'' month from sys.dual

Line 1813: union select ''06'' month from sys.dual

1809: union select ''02'' month from sys.dual
1810: union select ''03'' month from sys.dual
1811: union select ''04'' month from sys.dual
1812: union select ''05'' month from sys.dual
1813: union select ''06'' month from sys.dual
1814: union select ''07'' month from sys.dual
1815: union select ''08'' month from sys.dual
1816: union select ''09'' month from sys.dual
1817: union select ''10'' month from sys.dual

Line 1814: union select ''07'' month from sys.dual

1810: union select ''03'' month from sys.dual
1811: union select ''04'' month from sys.dual
1812: union select ''05'' month from sys.dual
1813: union select ''06'' month from sys.dual
1814: union select ''07'' month from sys.dual
1815: union select ''08'' month from sys.dual
1816: union select ''09'' month from sys.dual
1817: union select ''10'' month from sys.dual
1818: union select ''11'' month from sys.dual

Line 1815: union select ''08'' month from sys.dual

1811: union select ''04'' month from sys.dual
1812: union select ''05'' month from sys.dual
1813: union select ''06'' month from sys.dual
1814: union select ''07'' month from sys.dual
1815: union select ''08'' month from sys.dual
1816: union select ''09'' month from sys.dual
1817: union select ''10'' month from sys.dual
1818: union select ''11'' month from sys.dual
1819: union select ''12'' month from sys.dual) m

Line 1816: union select ''09'' month from sys.dual

1812: union select ''05'' month from sys.dual
1813: union select ''06'' month from sys.dual
1814: union select ''07'' month from sys.dual
1815: union select ''08'' month from sys.dual
1816: union select ''09'' month from sys.dual
1817: union select ''10'' month from sys.dual
1818: union select ''11'' month from sys.dual
1819: union select ''12'' month from sys.dual) m
1820: where a.establishment_id = v.establishment_id

Line 1817: union select ''10'' month from sys.dual

1813: union select ''06'' month from sys.dual
1814: union select ''07'' month from sys.dual
1815: union select ''08'' month from sys.dual
1816: union select ''09'' month from sys.dual
1817: union select ''10'' month from sys.dual
1818: union select ''11'' month from sys.dual
1819: union select ''12'' month from sys.dual) m
1820: where a.establishment_id = v.establishment_id
1821: and a.assignment_status_type_id = per_ast.assignment_status_type_id

Line 1818: union select ''11'' month from sys.dual

1814: union select ''07'' month from sys.dual
1815: union select ''08'' month from sys.dual
1816: union select ''09'' month from sys.dual
1817: union select ''10'' month from sys.dual
1818: union select ''11'' month from sys.dual
1819: union select ''12'' month from sys.dual) m
1820: where a.establishment_id = v.establishment_id
1821: and a.assignment_status_type_id = per_ast.assignment_status_type_id
1822: and a.assignment_type = ''E''

Line 1819: union select ''12'' month from sys.dual) m

1815: union select ''08'' month from sys.dual
1816: union select ''09'' month from sys.dual
1817: union select ''10'' month from sys.dual
1818: union select ''11'' month from sys.dual
1819: union select ''12'' month from sys.dual) m
1820: where a.establishment_id = v.establishment_id
1821: and a.assignment_status_type_id = per_ast.assignment_status_type_id
1822: and a.assignment_type = ''E''
1823: and userenv(''lang'')=pt.language

Line 1895: , (select ''01'' month from sys.dual

1891: , per_all_people_f p
1892: , per_assignment_status_types per_ast
1893: , per_all_assignments_f a
1894: , P_ESTABLISHMENT_TABLE
1895: , (select ''01'' month from sys.dual
1896: union select ''02'' month from sys.dual
1897: union select ''03'' month from sys.dual
1898: union select ''04'' month from sys.dual
1899: union select ''05'' month from sys.dual

Line 1896: union select ''02'' month from sys.dual

1892: , per_assignment_status_types per_ast
1893: , per_all_assignments_f a
1894: , P_ESTABLISHMENT_TABLE
1895: , (select ''01'' month from sys.dual
1896: union select ''02'' month from sys.dual
1897: union select ''03'' month from sys.dual
1898: union select ''04'' month from sys.dual
1899: union select ''05'' month from sys.dual
1900: union select ''06'' month from sys.dual

Line 1897: union select ''03'' month from sys.dual

1893: , per_all_assignments_f a
1894: , P_ESTABLISHMENT_TABLE
1895: , (select ''01'' month from sys.dual
1896: union select ''02'' month from sys.dual
1897: union select ''03'' month from sys.dual
1898: union select ''04'' month from sys.dual
1899: union select ''05'' month from sys.dual
1900: union select ''06'' month from sys.dual
1901: union select ''07'' month from sys.dual

Line 1898: union select ''04'' month from sys.dual

1894: , P_ESTABLISHMENT_TABLE
1895: , (select ''01'' month from sys.dual
1896: union select ''02'' month from sys.dual
1897: union select ''03'' month from sys.dual
1898: union select ''04'' month from sys.dual
1899: union select ''05'' month from sys.dual
1900: union select ''06'' month from sys.dual
1901: union select ''07'' month from sys.dual
1902: union select ''08'' month from sys.dual

Line 1899: union select ''05'' month from sys.dual

1895: , (select ''01'' month from sys.dual
1896: union select ''02'' month from sys.dual
1897: union select ''03'' month from sys.dual
1898: union select ''04'' month from sys.dual
1899: union select ''05'' month from sys.dual
1900: union select ''06'' month from sys.dual
1901: union select ''07'' month from sys.dual
1902: union select ''08'' month from sys.dual
1903: union select ''09'' month from sys.dual

Line 1900: union select ''06'' month from sys.dual

1896: union select ''02'' month from sys.dual
1897: union select ''03'' month from sys.dual
1898: union select ''04'' month from sys.dual
1899: union select ''05'' month from sys.dual
1900: union select ''06'' month from sys.dual
1901: union select ''07'' month from sys.dual
1902: union select ''08'' month from sys.dual
1903: union select ''09'' month from sys.dual
1904: union select ''10'' month from sys.dual

Line 1901: union select ''07'' month from sys.dual

1897: union select ''03'' month from sys.dual
1898: union select ''04'' month from sys.dual
1899: union select ''05'' month from sys.dual
1900: union select ''06'' month from sys.dual
1901: union select ''07'' month from sys.dual
1902: union select ''08'' month from sys.dual
1903: union select ''09'' month from sys.dual
1904: union select ''10'' month from sys.dual
1905: union select ''11'' month from sys.dual

Line 1902: union select ''08'' month from sys.dual

1898: union select ''04'' month from sys.dual
1899: union select ''05'' month from sys.dual
1900: union select ''06'' month from sys.dual
1901: union select ''07'' month from sys.dual
1902: union select ''08'' month from sys.dual
1903: union select ''09'' month from sys.dual
1904: union select ''10'' month from sys.dual
1905: union select ''11'' month from sys.dual
1906: union select ''12'' month from sys.dual) m

Line 1903: union select ''09'' month from sys.dual

1899: union select ''05'' month from sys.dual
1900: union select ''06'' month from sys.dual
1901: union select ''07'' month from sys.dual
1902: union select ''08'' month from sys.dual
1903: union select ''09'' month from sys.dual
1904: union select ''10'' month from sys.dual
1905: union select ''11'' month from sys.dual
1906: union select ''12'' month from sys.dual) m
1907: where a.establishment_id = v.establishment_id

Line 1904: union select ''10'' month from sys.dual

1900: union select ''06'' month from sys.dual
1901: union select ''07'' month from sys.dual
1902: union select ''08'' month from sys.dual
1903: union select ''09'' month from sys.dual
1904: union select ''10'' month from sys.dual
1905: union select ''11'' month from sys.dual
1906: union select ''12'' month from sys.dual) m
1907: where a.establishment_id = v.establishment_id
1908: and userenv(''lang'')=pt.language

Line 1905: union select ''11'' month from sys.dual

1901: union select ''07'' month from sys.dual
1902: union select ''08'' month from sys.dual
1903: union select ''09'' month from sys.dual
1904: union select ''10'' month from sys.dual
1905: union select ''11'' month from sys.dual
1906: union select ''12'' month from sys.dual) m
1907: where a.establishment_id = v.establishment_id
1908: and userenv(''lang'')=pt.language
1909: and a.assignment_status_type_id = per_ast.assignment_status_type_id

Line 1906: union select ''12'' month from sys.dual) m

1902: union select ''08'' month from sys.dual
1903: union select ''09'' month from sys.dual
1904: union select ''10'' month from sys.dual
1905: union select ''11'' month from sys.dual
1906: union select ''12'' month from sys.dual) m
1907: where a.establishment_id = v.establishment_id
1908: and userenv(''lang'')=pt.language
1909: and a.assignment_status_type_id = per_ast.assignment_status_type_id
1910: and a.assignment_type = ''E''

Line 1984: , (select ''01'' month from sys.dual

1980: , per_bf_balances_v bal
1981: , per_person_types_tl pt
1982: , per_all_people_f p
1983: , per_all_assignments_f a
1984: , (select ''01'' month from sys.dual
1985: union select ''02'' month from sys.dual
1986: union select ''03'' month from sys.dual
1987: union select ''04'' month from sys.dual
1988: union select ''05'' month from sys.dual

Line 1985: union select ''02'' month from sys.dual

1981: , per_person_types_tl pt
1982: , per_all_people_f p
1983: , per_all_assignments_f a
1984: , (select ''01'' month from sys.dual
1985: union select ''02'' month from sys.dual
1986: union select ''03'' month from sys.dual
1987: union select ''04'' month from sys.dual
1988: union select ''05'' month from sys.dual
1989: union select ''06'' month from sys.dual

Line 1986: union select ''03'' month from sys.dual

1982: , per_all_people_f p
1983: , per_all_assignments_f a
1984: , (select ''01'' month from sys.dual
1985: union select ''02'' month from sys.dual
1986: union select ''03'' month from sys.dual
1987: union select ''04'' month from sys.dual
1988: union select ''05'' month from sys.dual
1989: union select ''06'' month from sys.dual
1990: union select ''07'' month from sys.dual

Line 1987: union select ''04'' month from sys.dual

1983: , per_all_assignments_f a
1984: , (select ''01'' month from sys.dual
1985: union select ''02'' month from sys.dual
1986: union select ''03'' month from sys.dual
1987: union select ''04'' month from sys.dual
1988: union select ''05'' month from sys.dual
1989: union select ''06'' month from sys.dual
1990: union select ''07'' month from sys.dual
1991: union select ''08'' month from sys.dual

Line 1988: union select ''05'' month from sys.dual

1984: , (select ''01'' month from sys.dual
1985: union select ''02'' month from sys.dual
1986: union select ''03'' month from sys.dual
1987: union select ''04'' month from sys.dual
1988: union select ''05'' month from sys.dual
1989: union select ''06'' month from sys.dual
1990: union select ''07'' month from sys.dual
1991: union select ''08'' month from sys.dual
1992: union select ''09'' month from sys.dual

Line 1989: union select ''06'' month from sys.dual

1985: union select ''02'' month from sys.dual
1986: union select ''03'' month from sys.dual
1987: union select ''04'' month from sys.dual
1988: union select ''05'' month from sys.dual
1989: union select ''06'' month from sys.dual
1990: union select ''07'' month from sys.dual
1991: union select ''08'' month from sys.dual
1992: union select ''09'' month from sys.dual
1993: union select ''10'' month from sys.dual

Line 1990: union select ''07'' month from sys.dual

1986: union select ''03'' month from sys.dual
1987: union select ''04'' month from sys.dual
1988: union select ''05'' month from sys.dual
1989: union select ''06'' month from sys.dual
1990: union select ''07'' month from sys.dual
1991: union select ''08'' month from sys.dual
1992: union select ''09'' month from sys.dual
1993: union select ''10'' month from sys.dual
1994: union select ''11'' month from sys.dual

Line 1991: union select ''08'' month from sys.dual

1987: union select ''04'' month from sys.dual
1988: union select ''05'' month from sys.dual
1989: union select ''06'' month from sys.dual
1990: union select ''07'' month from sys.dual
1991: union select ''08'' month from sys.dual
1992: union select ''09'' month from sys.dual
1993: union select ''10'' month from sys.dual
1994: union select ''11'' month from sys.dual
1995: union select ''12'' month from sys.dual) m

Line 1992: union select ''09'' month from sys.dual

1988: union select ''05'' month from sys.dual
1989: union select ''06'' month from sys.dual
1990: union select ''07'' month from sys.dual
1991: union select ''08'' month from sys.dual
1992: union select ''09'' month from sys.dual
1993: union select ''10'' month from sys.dual
1994: union select ''11'' month from sys.dual
1995: union select ''12'' month from sys.dual) m
1996: where (p.effective_start_date,a.effective_start_date) =

Line 1993: union select ''10'' month from sys.dual

1989: union select ''06'' month from sys.dual
1990: union select ''07'' month from sys.dual
1991: union select ''08'' month from sys.dual
1992: union select ''09'' month from sys.dual
1993: union select ''10'' month from sys.dual
1994: union select ''11'' month from sys.dual
1995: union select ''12'' month from sys.dual) m
1996: where (p.effective_start_date,a.effective_start_date) =
1997: (select max(p2.effective_start_date),max(a2.effective_start_date)

Line 1994: union select ''11'' month from sys.dual

1990: union select ''07'' month from sys.dual
1991: union select ''08'' month from sys.dual
1992: union select ''09'' month from sys.dual
1993: union select ''10'' month from sys.dual
1994: union select ''11'' month from sys.dual
1995: union select ''12'' month from sys.dual) m
1996: where (p.effective_start_date,a.effective_start_date) =
1997: (select max(p2.effective_start_date),max(a2.effective_start_date)
1998: from per_person_types_tl pt2

Line 1995: union select ''12'' month from sys.dual) m

1991: union select ''08'' month from sys.dual
1992: union select ''09'' month from sys.dual
1993: union select ''10'' month from sys.dual
1994: union select ''11'' month from sys.dual
1995: union select ''12'' month from sys.dual) m
1996: where (p.effective_start_date,a.effective_start_date) =
1997: (select max(p2.effective_start_date),max(a2.effective_start_date)
1998: from per_person_types_tl pt2
1999: , per_all_people_f p2

Line 2072: , (select ''01'' month from sys.dual

2068: , per_all_people_f p
2069: , per_assignment_status_types per_ast
2070: , per_all_assignments_f a
2071: , P_ESTABLISHMENT_TABLE
2072: , (select ''01'' month from sys.dual
2073: union select ''02'' month from sys.dual
2074: union select ''03'' month from sys.dual
2075: union select ''04'' month from sys.dual
2076: union select ''05'' month from sys.dual

Line 2073: union select ''02'' month from sys.dual

2069: , per_assignment_status_types per_ast
2070: , per_all_assignments_f a
2071: , P_ESTABLISHMENT_TABLE
2072: , (select ''01'' month from sys.dual
2073: union select ''02'' month from sys.dual
2074: union select ''03'' month from sys.dual
2075: union select ''04'' month from sys.dual
2076: union select ''05'' month from sys.dual
2077: union select ''06'' month from sys.dual

Line 2074: union select ''03'' month from sys.dual

2070: , per_all_assignments_f a
2071: , P_ESTABLISHMENT_TABLE
2072: , (select ''01'' month from sys.dual
2073: union select ''02'' month from sys.dual
2074: union select ''03'' month from sys.dual
2075: union select ''04'' month from sys.dual
2076: union select ''05'' month from sys.dual
2077: union select ''06'' month from sys.dual
2078: union select ''07'' month from sys.dual

Line 2075: union select ''04'' month from sys.dual

2071: , P_ESTABLISHMENT_TABLE
2072: , (select ''01'' month from sys.dual
2073: union select ''02'' month from sys.dual
2074: union select ''03'' month from sys.dual
2075: union select ''04'' month from sys.dual
2076: union select ''05'' month from sys.dual
2077: union select ''06'' month from sys.dual
2078: union select ''07'' month from sys.dual
2079: union select ''08'' month from sys.dual

Line 2076: union select ''05'' month from sys.dual

2072: , (select ''01'' month from sys.dual
2073: union select ''02'' month from sys.dual
2074: union select ''03'' month from sys.dual
2075: union select ''04'' month from sys.dual
2076: union select ''05'' month from sys.dual
2077: union select ''06'' month from sys.dual
2078: union select ''07'' month from sys.dual
2079: union select ''08'' month from sys.dual
2080: union select ''09'' month from sys.dual

Line 2077: union select ''06'' month from sys.dual

2073: union select ''02'' month from sys.dual
2074: union select ''03'' month from sys.dual
2075: union select ''04'' month from sys.dual
2076: union select ''05'' month from sys.dual
2077: union select ''06'' month from sys.dual
2078: union select ''07'' month from sys.dual
2079: union select ''08'' month from sys.dual
2080: union select ''09'' month from sys.dual
2081: union select ''10'' month from sys.dual

Line 2078: union select ''07'' month from sys.dual

2074: union select ''03'' month from sys.dual
2075: union select ''04'' month from sys.dual
2076: union select ''05'' month from sys.dual
2077: union select ''06'' month from sys.dual
2078: union select ''07'' month from sys.dual
2079: union select ''08'' month from sys.dual
2080: union select ''09'' month from sys.dual
2081: union select ''10'' month from sys.dual
2082: union select ''11'' month from sys.dual

Line 2079: union select ''08'' month from sys.dual

2075: union select ''04'' month from sys.dual
2076: union select ''05'' month from sys.dual
2077: union select ''06'' month from sys.dual
2078: union select ''07'' month from sys.dual
2079: union select ''08'' month from sys.dual
2080: union select ''09'' month from sys.dual
2081: union select ''10'' month from sys.dual
2082: union select ''11'' month from sys.dual
2083: union select ''12'' month from sys.dual) m

Line 2080: union select ''09'' month from sys.dual

2076: union select ''05'' month from sys.dual
2077: union select ''06'' month from sys.dual
2078: union select ''07'' month from sys.dual
2079: union select ''08'' month from sys.dual
2080: union select ''09'' month from sys.dual
2081: union select ''10'' month from sys.dual
2082: union select ''11'' month from sys.dual
2083: union select ''12'' month from sys.dual) m
2084: where a.establishment_id = v.establishment_id

Line 2081: union select ''10'' month from sys.dual

2077: union select ''06'' month from sys.dual
2078: union select ''07'' month from sys.dual
2079: union select ''08'' month from sys.dual
2080: union select ''09'' month from sys.dual
2081: union select ''10'' month from sys.dual
2082: union select ''11'' month from sys.dual
2083: union select ''12'' month from sys.dual) m
2084: where a.establishment_id = v.establishment_id
2085: and userenv(''lang'')=pt.language

Line 2082: union select ''11'' month from sys.dual

2078: union select ''07'' month from sys.dual
2079: union select ''08'' month from sys.dual
2080: union select ''09'' month from sys.dual
2081: union select ''10'' month from sys.dual
2082: union select ''11'' month from sys.dual
2083: union select ''12'' month from sys.dual) m
2084: where a.establishment_id = v.establishment_id
2085: and userenv(''lang'')=pt.language
2086: and a.assignment_status_type_id = per_ast.assignment_status_type_id

Line 2083: union select ''12'' month from sys.dual) m

2079: union select ''08'' month from sys.dual
2080: union select ''09'' month from sys.dual
2081: union select ''10'' month from sys.dual
2082: union select ''11'' month from sys.dual
2083: union select ''12'' month from sys.dual) m
2084: where a.establishment_id = v.establishment_id
2085: and userenv(''lang'')=pt.language
2086: and a.assignment_status_type_id = per_ast.assignment_status_type_id
2087: and a.assignment_type = ''E''

Line 2152: , (select ''01'' month from sys.dual

2148: , per_all_people_f p
2149: , per_assignment_status_types per_ast
2150: , per_all_assignments_f a
2151: , P_ESTABLISHMENT_TABLE
2152: , (select ''01'' month from sys.dual
2153: union select ''02'' month from sys.dual
2154: union select ''03'' month from sys.dual
2155: union select ''04'' month from sys.dual
2156: union select ''05'' month from sys.dual

Line 2153: union select ''02'' month from sys.dual

2149: , per_assignment_status_types per_ast
2150: , per_all_assignments_f a
2151: , P_ESTABLISHMENT_TABLE
2152: , (select ''01'' month from sys.dual
2153: union select ''02'' month from sys.dual
2154: union select ''03'' month from sys.dual
2155: union select ''04'' month from sys.dual
2156: union select ''05'' month from sys.dual
2157: union select ''06'' month from sys.dual

Line 2154: union select ''03'' month from sys.dual

2150: , per_all_assignments_f a
2151: , P_ESTABLISHMENT_TABLE
2152: , (select ''01'' month from sys.dual
2153: union select ''02'' month from sys.dual
2154: union select ''03'' month from sys.dual
2155: union select ''04'' month from sys.dual
2156: union select ''05'' month from sys.dual
2157: union select ''06'' month from sys.dual
2158: union select ''07'' month from sys.dual

Line 2155: union select ''04'' month from sys.dual

2151: , P_ESTABLISHMENT_TABLE
2152: , (select ''01'' month from sys.dual
2153: union select ''02'' month from sys.dual
2154: union select ''03'' month from sys.dual
2155: union select ''04'' month from sys.dual
2156: union select ''05'' month from sys.dual
2157: union select ''06'' month from sys.dual
2158: union select ''07'' month from sys.dual
2159: union select ''08'' month from sys.dual

Line 2156: union select ''05'' month from sys.dual

2152: , (select ''01'' month from sys.dual
2153: union select ''02'' month from sys.dual
2154: union select ''03'' month from sys.dual
2155: union select ''04'' month from sys.dual
2156: union select ''05'' month from sys.dual
2157: union select ''06'' month from sys.dual
2158: union select ''07'' month from sys.dual
2159: union select ''08'' month from sys.dual
2160: union select ''09'' month from sys.dual

Line 2157: union select ''06'' month from sys.dual

2153: union select ''02'' month from sys.dual
2154: union select ''03'' month from sys.dual
2155: union select ''04'' month from sys.dual
2156: union select ''05'' month from sys.dual
2157: union select ''06'' month from sys.dual
2158: union select ''07'' month from sys.dual
2159: union select ''08'' month from sys.dual
2160: union select ''09'' month from sys.dual
2161: union select ''10'' month from sys.dual

Line 2158: union select ''07'' month from sys.dual

2154: union select ''03'' month from sys.dual
2155: union select ''04'' month from sys.dual
2156: union select ''05'' month from sys.dual
2157: union select ''06'' month from sys.dual
2158: union select ''07'' month from sys.dual
2159: union select ''08'' month from sys.dual
2160: union select ''09'' month from sys.dual
2161: union select ''10'' month from sys.dual
2162: union select ''11'' month from sys.dual

Line 2159: union select ''08'' month from sys.dual

2155: union select ''04'' month from sys.dual
2156: union select ''05'' month from sys.dual
2157: union select ''06'' month from sys.dual
2158: union select ''07'' month from sys.dual
2159: union select ''08'' month from sys.dual
2160: union select ''09'' month from sys.dual
2161: union select ''10'' month from sys.dual
2162: union select ''11'' month from sys.dual
2163: union select ''12'' month from sys.dual) m

Line 2160: union select ''09'' month from sys.dual

2156: union select ''05'' month from sys.dual
2157: union select ''06'' month from sys.dual
2158: union select ''07'' month from sys.dual
2159: union select ''08'' month from sys.dual
2160: union select ''09'' month from sys.dual
2161: union select ''10'' month from sys.dual
2162: union select ''11'' month from sys.dual
2163: union select ''12'' month from sys.dual) m
2164: where a.establishment_id = v.establishment_id

Line 2161: union select ''10'' month from sys.dual

2157: union select ''06'' month from sys.dual
2158: union select ''07'' month from sys.dual
2159: union select ''08'' month from sys.dual
2160: union select ''09'' month from sys.dual
2161: union select ''10'' month from sys.dual
2162: union select ''11'' month from sys.dual
2163: union select ''12'' month from sys.dual) m
2164: where a.establishment_id = v.establishment_id
2165: and a.assignment_status_type_id = per_ast.assignment_status_type_id

Line 2162: union select ''11'' month from sys.dual

2158: union select ''07'' month from sys.dual
2159: union select ''08'' month from sys.dual
2160: union select ''09'' month from sys.dual
2161: union select ''10'' month from sys.dual
2162: union select ''11'' month from sys.dual
2163: union select ''12'' month from sys.dual) m
2164: where a.establishment_id = v.establishment_id
2165: and a.assignment_status_type_id = per_ast.assignment_status_type_id
2166: and a.assignment_type = ''E''

Line 2163: union select ''12'' month from sys.dual) m

2159: union select ''08'' month from sys.dual
2160: union select ''09'' month from sys.dual
2161: union select ''10'' month from sys.dual
2162: union select ''11'' month from sys.dual
2163: union select ''12'' month from sys.dual) m
2164: where a.establishment_id = v.establishment_id
2165: and a.assignment_status_type_id = per_ast.assignment_status_type_id
2166: and a.assignment_type = ''E''
2167: RESTRICTION.PRIMARY_FLAG[a]

Line 6588: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id)

6584: hr_summary_api.CREATE_VALID_RESTRICTION (p_valid_restriction_id => l_id_value
6585: ,p_business_group_id => p_business_group_id
6586: ,p_object_version_number => l_object_version_number
6587: ,p_seeded_data => 'Y'
6588: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id)
6589: ,p_restriction_type_id => hr_summary_api.get_id('EMPLOYMENT_CATEGORY','RESTRICTION_TYPE',p_business_group_id));
6590: --
6591: hr_summary_api.CREATE_VALID_RESTRICTION (p_valid_restriction_id => l_id_value
6592: ,p_business_group_id => p_business_group_id

Line 6595: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id)

6591: hr_summary_api.CREATE_VALID_RESTRICTION (p_valid_restriction_id => l_id_value
6592: ,p_business_group_id => p_business_group_id
6593: ,p_object_version_number => l_object_version_number
6594: ,p_seeded_data => 'Y'
6595: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id)
6596: ,p_restriction_type_id => hr_summary_api.get_id('WORK_PATTERN','RESTRICTION_TYPE',p_business_group_id));
6597: --
6598: hr_summary_api.CREATE_VALID_RESTRICTION (p_valid_restriction_id => l_id_value
6599: ,p_business_group_id => p_business_group_id

Line 6602: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id)

6598: hr_summary_api.CREATE_VALID_RESTRICTION (p_valid_restriction_id => l_id_value
6599: ,p_business_group_id => p_business_group_id
6600: ,p_object_version_number => l_object_version_number
6601: ,p_seeded_data => 'Y'
6602: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id)
6603: ,p_restriction_type_id => hr_summary_api.get_id('ASSIGNMENT_STATUS_TYPE','RESTRICTION_TYPE',p_business_group_id));
6604: --
6605: hr_summary_api.CREATE_VALID_RESTRICTION (p_valid_restriction_id => l_id_value
6606: ,p_business_group_id => p_business_group_id

Line 6609: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id)

6605: hr_summary_api.CREATE_VALID_RESTRICTION (p_valid_restriction_id => l_id_value
6606: ,p_business_group_id => p_business_group_id
6607: ,p_object_version_number => l_object_version_number
6608: ,p_seeded_data => 'Y'
6609: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id)
6610: ,p_restriction_type_id => hr_summary_api.get_id('NEW_USER_PERSON_TYPE','RESTRICTION_TYPE',p_business_group_id));
6611: --
6612: hr_summary_api.CREATE_VALID_RESTRICTION (p_valid_restriction_id => l_id_value
6613: ,p_business_group_id => p_business_group_id

Line 6616: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id)

6612: hr_summary_api.CREATE_VALID_RESTRICTION (p_valid_restriction_id => l_id_value
6613: ,p_business_group_id => p_business_group_id
6614: ,p_object_version_number => l_object_version_number
6615: ,p_seeded_data => 'Y'
6616: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id)
6617: ,p_restriction_type_id => hr_summary_api.get_id('PRIMARY_FLAG','RESTRICTION_TYPE',p_business_group_id));
6618: --
6619: hr_summary_api.CREATE_VALID_RESTRICTION (p_valid_restriction_id => l_id_value
6620: ,p_business_group_id => p_business_group_id

Line 7712: ,p_name => 'Individual Work Pattern'

7708: hr_summary_api.CREATE_ITEM_TYPE_USAGE (p_item_type_usage_id => l_id_value
7709: ,p_business_group_id => p_business_group_id
7710: ,p_object_version_number => l_object_version_number
7711: ,p_sequence_number => 62
7712: ,p_name => 'Individual Work Pattern'
7713: ,p_seeded_data => 'Y'
7714: ,p_template_id => l_template_id
7715: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id));
7716: --

Line 7715: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id));

7711: ,p_sequence_number => 62
7712: ,p_name => 'Individual Work Pattern'
7713: ,p_seeded_data => 'Y'
7714: ,p_template_id => l_template_id
7715: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id));
7716: --
7717: hr_summary_api.CREATE_ITEM_TYPE_USAGE (p_item_type_usage_id => l_id_value
7718: ,p_business_group_id => p_business_group_id
7719: ,p_object_version_number => l_object_version_number

Line 8234: ,p_name => 'Individual Work Pattern'

8230: hr_summary_api.CREATE_ITEM_TYPE_USAGE (p_item_type_usage_id => l_id_value
8231: ,p_business_group_id => p_business_group_id
8232: ,p_object_version_number => l_object_version_number
8233: ,p_sequence_number => 62
8234: ,p_name => 'Individual Work Pattern'
8235: ,p_seeded_data => 'Y'
8236: ,p_template_id => l_template_id
8237: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id));
8238: --

Line 8237: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id));

8233: ,p_sequence_number => 62
8234: ,p_name => 'Individual Work Pattern'
8235: ,p_seeded_data => 'Y'
8236: ,p_template_id => l_template_id
8237: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id));
8238: --
8239: hr_summary_api.CREATE_ITEM_TYPE_USAGE (p_item_type_usage_id => l_id_value
8240: ,p_business_group_id => p_business_group_id
8241: ,p_object_version_number => l_object_version_number

Line 9161: ,p_item_type_usage_id => hr_summary_api.get_itu_id(l_template_name,'INDIVIDUAL_WORK_PATTERN','Individual Work Pattern',p_business_group_id)

9157: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value
9158: ,p_business_group_id => p_business_group_id
9159: ,p_object_version_number => l_object_version_number
9160: ,p_seeded_data => 'Y'
9161: ,p_item_type_usage_id => hr_summary_api.get_itu_id(l_template_name,'INDIVIDUAL_WORK_PATTERN','Individual Work Pattern',p_business_group_id)
9162: ,p_valid_restriction_id => hr_summary_api.get_ru_id('ASSIGNMENT_STATUS_TYPE','INDIVIDUAL_WORK_PATTERN',p_business_group_id)
9163: ,p_restriction_type => 'IN');
9164: --
9165: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value

Line 9162: ,p_valid_restriction_id => hr_summary_api.get_ru_id('ASSIGNMENT_STATUS_TYPE','INDIVIDUAL_WORK_PATTERN',p_business_group_id)

9158: ,p_business_group_id => p_business_group_id
9159: ,p_object_version_number => l_object_version_number
9160: ,p_seeded_data => 'Y'
9161: ,p_item_type_usage_id => hr_summary_api.get_itu_id(l_template_name,'INDIVIDUAL_WORK_PATTERN','Individual Work Pattern',p_business_group_id)
9162: ,p_valid_restriction_id => hr_summary_api.get_ru_id('ASSIGNMENT_STATUS_TYPE','INDIVIDUAL_WORK_PATTERN',p_business_group_id)
9163: ,p_restriction_type => 'IN');
9164: --
9165: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value
9166: ,p_business_group_id => p_business_group_id

Line 9169: ,p_item_type_usage_id => hr_summary_api.get_itu_id(l_template_name,'INDIVIDUAL_WORK_PATTERN','Individual Work Pattern',p_business_group_id)

9165: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value
9166: ,p_business_group_id => p_business_group_id
9167: ,p_object_version_number => l_object_version_number
9168: ,p_seeded_data => 'Y'
9169: ,p_item_type_usage_id => hr_summary_api.get_itu_id(l_template_name,'INDIVIDUAL_WORK_PATTERN','Individual Work Pattern',p_business_group_id)
9170: ,p_valid_restriction_id => hr_summary_api.get_ru_id('EMPLOYMENT_CATEGORY','INDIVIDUAL_WORK_PATTERN',p_business_group_id)
9171: ,p_restriction_type => 'IN');
9172: --
9173: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value

Line 9170: ,p_valid_restriction_id => hr_summary_api.get_ru_id('EMPLOYMENT_CATEGORY','INDIVIDUAL_WORK_PATTERN',p_business_group_id)

9166: ,p_business_group_id => p_business_group_id
9167: ,p_object_version_number => l_object_version_number
9168: ,p_seeded_data => 'Y'
9169: ,p_item_type_usage_id => hr_summary_api.get_itu_id(l_template_name,'INDIVIDUAL_WORK_PATTERN','Individual Work Pattern',p_business_group_id)
9170: ,p_valid_restriction_id => hr_summary_api.get_ru_id('EMPLOYMENT_CATEGORY','INDIVIDUAL_WORK_PATTERN',p_business_group_id)
9171: ,p_restriction_type => 'IN');
9172: --
9173: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value
9174: ,p_business_group_id => p_business_group_id

Line 9177: ,p_item_type_usage_id => hr_summary_api.get_itu_id(l_template_name,'INDIVIDUAL_WORK_PATTERN','Individual Work Pattern',p_business_group_id)

9173: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value
9174: ,p_business_group_id => p_business_group_id
9175: ,p_object_version_number => l_object_version_number
9176: ,p_seeded_data => 'Y'
9177: ,p_item_type_usage_id => hr_summary_api.get_itu_id(l_template_name,'INDIVIDUAL_WORK_PATTERN','Individual Work Pattern',p_business_group_id)
9178: ,p_valid_restriction_id => hr_summary_api.get_ru_id('NEW_USER_PERSON_TYPE','INDIVIDUAL_WORK_PATTERN',p_business_group_id)
9179: ,p_restriction_type => 'IN');
9180: --
9181: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value

Line 9178: ,p_valid_restriction_id => hr_summary_api.get_ru_id('NEW_USER_PERSON_TYPE','INDIVIDUAL_WORK_PATTERN',p_business_group_id)

9174: ,p_business_group_id => p_business_group_id
9175: ,p_object_version_number => l_object_version_number
9176: ,p_seeded_data => 'Y'
9177: ,p_item_type_usage_id => hr_summary_api.get_itu_id(l_template_name,'INDIVIDUAL_WORK_PATTERN','Individual Work Pattern',p_business_group_id)
9178: ,p_valid_restriction_id => hr_summary_api.get_ru_id('NEW_USER_PERSON_TYPE','INDIVIDUAL_WORK_PATTERN',p_business_group_id)
9179: ,p_restriction_type => 'IN');
9180: --
9181: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value
9182: ,p_business_group_id => p_business_group_id

Line 9185: ,p_item_type_usage_id => hr_summary_api.get_itu_id(l_template_name,'INDIVIDUAL_WORK_PATTERN','Individual Work Pattern',p_business_group_id)

9181: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value
9182: ,p_business_group_id => p_business_group_id
9183: ,p_object_version_number => l_object_version_number
9184: ,p_seeded_data => 'Y'
9185: ,p_item_type_usage_id => hr_summary_api.get_itu_id(l_template_name,'INDIVIDUAL_WORK_PATTERN','Individual Work Pattern',p_business_group_id)
9186: ,p_valid_restriction_id => hr_summary_api.get_ru_id('WORK_PATTERN','INDIVIDUAL_WORK_PATTERN',p_business_group_id)
9187: ,p_restriction_type => 'IN');
9188: --
9189: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value

Line 9186: ,p_valid_restriction_id => hr_summary_api.get_ru_id('WORK_PATTERN','INDIVIDUAL_WORK_PATTERN',p_business_group_id)

9182: ,p_business_group_id => p_business_group_id
9183: ,p_object_version_number => l_object_version_number
9184: ,p_seeded_data => 'Y'
9185: ,p_item_type_usage_id => hr_summary_api.get_itu_id(l_template_name,'INDIVIDUAL_WORK_PATTERN','Individual Work Pattern',p_business_group_id)
9186: ,p_valid_restriction_id => hr_summary_api.get_ru_id('WORK_PATTERN','INDIVIDUAL_WORK_PATTERN',p_business_group_id)
9187: ,p_restriction_type => 'IN');
9188: --
9189: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value
9190: ,p_business_group_id => p_business_group_id

Line 11290: ,p_name => 'C4 - Number of employees on an individual work schedule'

11286: hr_summary_api.CREATE_ITEM_TYPE_USAGE (p_item_type_usage_id => l_id_value
11287: ,p_business_group_id => p_business_group_id
11288: ,p_object_version_number => l_object_version_number
11289: ,p_sequence_number => 62
11290: ,p_name => 'C4 - Number of employees on an individual work schedule'
11291: ,p_seeded_data => 'Y'
11292: ,p_template_id => l_template_id
11293: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id));
11294: --

Line 11293: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id));

11289: ,p_sequence_number => 62
11290: ,p_name => 'C4 - Number of employees on an individual work schedule'
11291: ,p_seeded_data => 'Y'
11292: ,p_template_id => l_template_id
11293: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id));
11294: --
11295: hr_summary_api.CREATE_ITEM_TYPE_USAGE (p_item_type_usage_id => l_id_value
11296: ,p_business_group_id => p_business_group_id
11297: ,p_object_version_number => l_object_version_number