APPS.PAY_FR_PAY_FILE dependencies on HR_GENERAL

Line 66: And nvl(org.date_to, hr_general.end_of_time);

62: 'FR_ESTAB_INFO')
63: And org.organization_id = ori_opm.organization_id
64: And org.business_group_id = p_bg_id
65: And P_date_earned between org.date_from
66: And nvl(org.date_to, hr_general.end_of_time);
67: --
68: if L_payers_id is null then
69: return lpad(' ',16);
70: elsif g_org_class = 'FR_SOCIETE' then

Line 92: Return hr_general.bool_to_char(p_estab_id = g_org_id);

88: where hoi.organization_id = p_estab_id
89: AND hoi.org_information_context = 'FR_ESTAB_INFO';
90: BEGIN
91: If g_org_class = 'FR_ETABLISSEMENT' THEN
92: Return hr_general.bool_to_char(p_estab_id = g_org_id);
93: ElsIf g_org_class = 'FR_SOCIETE' THEN
94: l_estab_tbl_ind := DBMS_UTILITY.get_hash_value(p_estab_id,1,1048576);
95: if not g_estab_tbl.exists(l_estab_tbl_ind)
96: or g_estab_tbl(l_estab_tbl_ind).estab_id <> p_estab_id

Line 103: Return hr_general.bool_to_char

99: Open csr_get_company;
100: Fetch csr_get_company into g_estab_tbl(l_estab_tbl_ind).Company_id;
101: Close csr_get_company;
102: end if;
103: Return hr_general.bool_to_char
104: (g_estab_tbl(l_estab_tbl_ind).Company_id = g_org_id);
105: else
106: return 'TRUE';
107: end if;