[Home] [Help]
1322: set_context( 'ASSIGNMENT_ACTION_ID', p_assignment_action_id );
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
1646: CURSOR get_latest_assactid( p_assignment_id IN NUMBER,
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
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
1707: and p_date between TP.start_date and TP.end_date;
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
1900: AND PACT.payroll_action_id = ASSACT.payroll_action_id
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
1914: AND PACT.payroll_action_id = ASSACT.payroll_action_id