[Home] [Help]
1323: begin
1324: select paa.assignment_id, paa.action_sequence, ppa.effective_date
1325: into l_assignment_id, l_action_sequence, l_assact_effdate
1326: from pay_assignment_actions paa,
1327: pay_payroll_actions ppa
1328: where paa.assignment_action_id = p_assignment_action_id
1329: and paa.payroll_action_id = ppa.payroll_action_id;
1330: exception
1331: when no_data_found then
1647: p_effective_date IN DATE ) IS
1648: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1649: paa.assignment_action_id),16))
1650: from pay_assignment_actions paa,
1651: pay_payroll_actions ppa
1652: where paa.assignment_id = p_assignment_id
1653: and ppa.payroll_action_id = paa.payroll_action_id
1654: and ppa.effective_date <= p_effective_date
1655: and ppa.action_type in ('R', 'Q', 'I', 'V', 'B' );
1698: BEGIN
1699: select TP.end_date + 1
1700: into l_return_val
1701: from per_time_periods TP,
1702: pay_payroll_actions PACT,
1703: pay_assignment_actions ASSACT
1704: where ASSACT.assignment_action_id = p_assactid
1705: and PACT.payroll_action_id = ASSACT.payroll_action_id
1706: and PACT.payroll_id = TP.payroll_id
1891:
1892: ELSIF p_dimension_name like '%Fiscal Quarter to Date' THEN
1893: SELECT fnd_date.canonical_to_date(org_information11)
1894: INTO l_beg_of_fiscal_year
1895: FROM pay_payroll_actions PACT,
1896: pay_assignment_actions ASSACT,
1897: hr_organization_information HOI
1898: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
1899: AND HOI.organization_id = PACT.business_group_id
1905:
1906: ELSIF p_dimension_name like '%Fiscal Year to Date' THEN
1907: SELECT fnd_date.canonical_to_date(org_information11)
1908: INTO l_beg_of_fiscal_year
1909: FROM pay_payroll_actions PACT,
1910: pay_assignment_actions ASSACT,
1911: hr_organization_information HOI
1912: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
1913: AND HOI.organization_id = PACT.business_group_id