APPS.PYZAEXC dependencies on PAY_PAYROLL_ACTIONS

Line 71: pay_payroll_actions

67: date_earned, payroll_id
68: into
69: l_owner_date_earned, l_owner_payroll_id
70: from
71: pay_payroll_actions
72: where
73: payroll_action_id = p_owner_payroll_action_id;
74:
75: -- Get the user's date earned and payroll id

Line 81: pay_payroll_actions

77: date_earned, payroll_id
78: into
79: l_user_date_earned, l_user_payroll_id
80: from
81: pay_payroll_actions
82: where
83: payroll_action_id = p_user_payroll_action_id;
84:
85: -- Get the owner's tax year

Line 244: pay_payroll_actions

240: date_earned, payroll_id
241: into
242: l_owner_date_earned, l_owner_payroll_id
243: from
244: pay_payroll_actions
245: where
246: payroll_action_id = p_owner_payroll_action_id;
247:
248: -- Get the user's date earned and payroll id

Line 254: pay_payroll_actions

250: date_earned, payroll_id
251: into
252: l_user_date_earned, l_user_payroll_id
253: from
254: pay_payroll_actions
255: where
256: payroll_action_id = p_user_payroll_action_id;
257:
258: -- Get the owner's calendar year

Line 382: pay_payroll_actions

378: date_earned, payroll_id
379: into
380: l_owner_date_earned, l_owner_payroll_id
381: from
382: pay_payroll_actions
383: where
384: payroll_action_id = p_owner_payroll_action_id;
385:
386: -- Get the user's date earned and payroll id

Line 392: pay_payroll_actions

388: date_earned, payroll_id
389: into
390: l_user_date_earned, l_user_payroll_id
391: from
392: pay_payroll_actions
393: where
394: payroll_action_id = p_user_payroll_action_id;
395:
396: -- Get the owner's tax quarter and tax year

Line 542: pay_payroll_actions

538: date_earned, payroll_id
539: into
540: l_owner_date_earned, l_owner_payroll_id
541: from
542: pay_payroll_actions
543: where
544: payroll_action_id = p_owner_payroll_action_id;
545:
546: -- Get the user's date earned and payroll id

Line 552: pay_payroll_actions

548: date_earned, payroll_id
549: into
550: l_user_date_earned, l_user_payroll_id
551: from
552: pay_payroll_actions
553: where
554: payroll_action_id = p_user_payroll_action_id;
555:
556: -- Get the owner's month end

Line 673: pay_payroll_actions

669: time_period_id
670: into
671: l_owner_time_period_id
672: from
673: pay_payroll_actions
674: where
675: payroll_action_id = p_owner_payroll_action_id;
676:
677: -- Get the user's time_period_id

Line 683: pay_payroll_actions

679: time_period_id
680: into
681: l_user_time_period_id
682: from
683: pay_payroll_actions
684: where
685: payroll_action_id = p_user_payroll_action_id;
686:
687:

Line 731: ,pay_payroll_actions ppa

727: BEGIN
728: SELECT ptp.end_date
729: INTO p_expiry_information
730: FROM per_time_periods ptp
731: ,pay_payroll_actions ppa
732: WHERE ppa.payroll_action_id = p_owner_payroll_action_id
733: AND ppa.payroll_id = ptp.payroll_id
734: AND p_owner_effective_date BETWEEN ptp.start_date AND ptp.end_date;
735: END ASG_PTD_EC;