DBA Data[Home] [Help]

APPS.PAY_PAYSLIP_UTIL dependencies on FND_DATE

Line 98: ,p_effective_date in date default fnd_date.canonical_to_date('1990/01/01'))

94:
95: FUNCTION get_id_for_employer_address( p_business_group_id in number
96: ,p_tax_unit_id in number
97: ,p_organization_id in number
98: ,p_effective_date in date default fnd_date.canonical_to_date('1990/01/01'))
99: RETURN NUMBER IS
100:
101: cursor get_legi_rule(cp_legislation_code varchar2) is
102: select rule_mode

Line 113: ,fnd_date.canonical_to_date(hoi.org_information11)

109: and rule_type = 'PAYSLIP_EMPLYR_ADDR';
110:
111: cursor c_get_payslip_date_from(cp_business_group_id number) is
112: select hoi.org_information10
113: ,fnd_date.canonical_to_date(hoi.org_information11)
114: from hr_organization_information hoi
115: where hoi.organization_id = cp_business_group_id
116: and hoi.org_information_context like 'HR_SELF_SERVICE_BG_PREFERENCE'
117: and hoi.org_information1 = 'PAYSLIP';