APPS.PAY_GB_TAX_CREDIT_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 247: pay_assignment_actions paa,

243: ) is
244: select 'Y'
245: from per_time_periods ptp,
246: pay_payroll_actions ppa,
247: pay_assignment_actions paa,
248: per_all_assignments_f asg
249: where asg.assignment_id = p_asg
250: and asg.payroll_id = ppa.payroll_id
251: and paa.assignment_id = asg.assignment_id

Line 570: pay_assignment_actions paa,

566:
567: cursor c_purge_allowed(p_asg in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE) is
568: select max(effective_date)
569: from pay_payroll_actions ppa,
570: pay_assignment_actions paa,
571: per_all_assignments_f asg
572: where asg.assignment_id = p_asg
573: and asg.assignment_id = paa.assignment_id
574: and paa.payroll_action_id = ppa.payroll_action_id

Line 675: p_assignment_id in PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ID%TYPE,

671:
672: END Check_Daily_Rate;
673:
674: PROCEDURE Fetch_Balances(
675: p_assignment_id in PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ID%TYPE,
676: p_element_entry_id in PAY_RUN_RESULTS.SOURCE_ID%TYPE,
677: p_itd_balance OUT NOCOPY NUMBER,
678: p_ptd_balance OUT NOCOPY NUMBER
679: ) is

Line 695: FROM pay_assignment_actions paa,

691: pay_element_types_f ele
692: where prr.assignment_action_id in (
693: SELECT to_number(substr(max(lpad(paa.action_sequence,15,'0')||
694: paa.assignment_action_id),16))
695: FROM pay_assignment_actions paa,
696: pay_payroll_actions ppa,
697: per_time_periods ptp,
698: fnd_sessions ses
699: WHERE paa.assignment_id = p_asg

Line 719: from pay_assignment_actions paa,

715: pay_element_types_f ele
716: where prr.assignment_action_id in (
717: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||
718: paa.assignment_action_id),16))
719: from pay_assignment_actions paa,
720: pay_payroll_actions ppa,
721: fnd_sessions ses,
722: per_time_periods ptp,
723: per_all_assignments per

Line 739: l_itd_action_id PAY_ASSIGNMENT_ACTIONS.assignment_action_id%TYPE;

735: and ele.element_name = 'Tax Credit'
736: and prr.source_id = p_ent;
737:
738: l_proc VARCHAR(72) := g_package||'.FETCH_BALANCES';
739: l_itd_action_id PAY_ASSIGNMENT_ACTIONS.assignment_action_id%TYPE;
740: l_itd_source_id PAY_RUN_RESULTS.source_id%TYPE;
741: l_ptd_action_id PAY_ASSIGNMENT_ACTIONS.assignment_action_id%TYPE;
742: l_ptd_source_id PAY_RUN_RESULTS.source_id%TYPE;
743: l_balance_type_id PAY_BALANCE_TYPES.balance_type_id%TYPE;

Line 741: l_ptd_action_id PAY_ASSIGNMENT_ACTIONS.assignment_action_id%TYPE;

737:
738: l_proc VARCHAR(72) := g_package||'.FETCH_BALANCES';
739: l_itd_action_id PAY_ASSIGNMENT_ACTIONS.assignment_action_id%TYPE;
740: l_itd_source_id PAY_RUN_RESULTS.source_id%TYPE;
741: l_ptd_action_id PAY_ASSIGNMENT_ACTIONS.assignment_action_id%TYPE;
742: l_ptd_source_id PAY_RUN_RESULTS.source_id%TYPE;
743: l_balance_type_id PAY_BALANCE_TYPES.balance_type_id%TYPE;
744: l_effective_date DATE;
745: