APPS.PAY_US_BALANCE_VIEW_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1330: from pay_assignment_actions paa,

1326: set_context( 'ASSIGNMENT_ACTION_ID', p_assignment_action_id );
1327: begin
1328: select paa.assignment_id, paa.action_sequence, ppa.effective_date
1329: into l_assignment_id, l_action_sequence, l_assact_effdate
1330: from pay_assignment_actions paa,
1331: pay_payroll_actions ppa
1332: where paa.assignment_action_id = p_assignment_action_id
1333: and paa.payroll_action_id = ppa.payroll_action_id;
1334: exception

Line 1655: from pay_assignment_actions paa,

1651: CURSOR get_latest_assactid( p_assignment_id IN NUMBER,
1652: p_effective_date IN DATE ) IS
1653: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1654: paa.assignment_action_id),16))
1655: from pay_assignment_actions paa,
1656: pay_payroll_actions ppa,
1657: per_assignments_f paf
1658: where paa.assignment_id = p_assignment_id
1659: and paf.assignment_id = p_assignment_id

Line 1711: pay_assignment_actions ASSACT

1707: select TP.end_date + 1
1708: into l_return_val
1709: from per_time_periods TP,
1710: pay_payroll_actions PACT,
1711: pay_assignment_actions ASSACT
1712: where ASSACT.assignment_action_id = p_assactid
1713: and PACT.payroll_action_id = ASSACT.payroll_action_id
1714: and PACT.payroll_id = TP.payroll_id
1715: and p_date between TP.start_date and TP.end_date;

Line 1904: pay_assignment_actions ASSACT,

1900: ELSIF p_dimension_name like '%Fiscal Quarter to Date' THEN
1901: SELECT fnd_date.canonical_to_date(org_information11)
1902: INTO l_beg_of_fiscal_year
1903: FROM pay_payroll_actions PACT,
1904: pay_assignment_actions ASSACT,
1905: hr_organization_information HOI
1906: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
1907: AND HOI.organization_id = PACT.business_group_id
1908: AND PACT.payroll_action_id = ASSACT.payroll_action_id

Line 1918: pay_assignment_actions ASSACT,

1914: ELSIF p_dimension_name like '%Fiscal Year to Date' THEN
1915: SELECT fnd_date.canonical_to_date(org_information11)
1916: INTO l_beg_of_fiscal_year
1917: FROM pay_payroll_actions PACT,
1918: pay_assignment_actions ASSACT,
1919: hr_organization_information HOI
1920: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
1921: AND HOI.organization_id = PACT.business_group_id
1922: AND PACT.payroll_action_id = ASSACT.payroll_action_id