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 336: FROM pay_payroll_actions ppa

332: from dual; */
333:
334: SELECT max(ptpp.pay_advice_date)
335: INTO p_expiry_information
336: FROM pay_payroll_actions ppa
337: ,per_time_periods ptp
338: ,per_time_periods ptpp
339: WHERE ppa.payroll_action_id = p_owner_payroll_action_id
340: AND ppa.payroll_id = ptp.payroll_id

Line 394: pay_payroll_actions

390: date_earned, payroll_id
391: into
392: l_owner_date_earned, l_owner_payroll_id
393: from
394: pay_payroll_actions
395: where
396: payroll_action_id = p_owner_payroll_action_id;
397:
398: -- Get the user's date earned and payroll id

Line 404: pay_payroll_actions

400: date_earned, payroll_id
401: into
402: l_user_date_earned, l_user_payroll_id
403: from
404: pay_payroll_actions
405: where
406: payroll_action_id = p_user_payroll_action_id;
407:
408: -- Get the owner's tax quarter and tax year

Line 554: pay_payroll_actions

550: date_earned, payroll_id
551: into
552: l_owner_date_earned, l_owner_payroll_id
553: from
554: pay_payroll_actions
555: where
556: payroll_action_id = p_owner_payroll_action_id;
557:
558: -- Get the user's date earned and payroll id

Line 564: pay_payroll_actions

560: date_earned, payroll_id
561: into
562: l_user_date_earned, l_user_payroll_id
563: from
564: pay_payroll_actions
565: where
566: payroll_action_id = p_user_payroll_action_id;
567:
568: -- Get the owner's month end

Line 650: ,pay_payroll_actions ppa

646:
647: SELECT ptp.pay_advice_date
648: INTO p_expiry_information
649: FROM per_time_periods ptp
650: ,pay_payroll_actions ppa
651: WHERE ppa.payroll_action_id = p_owner_payroll_action_id
652: AND ppa.payroll_id = ptp.payroll_id
653: AND p_owner_effective_date BETWEEN ptp.start_date AND ptp.end_date;
654:

Line 696: pay_payroll_actions

692: time_period_id
693: into
694: l_owner_time_period_id
695: from
696: pay_payroll_actions
697: where
698: payroll_action_id = p_owner_payroll_action_id;
699:
700: -- Get the user's time_period_id

Line 706: pay_payroll_actions

702: time_period_id
703: into
704: l_user_time_period_id
705: from
706: pay_payroll_actions
707: where
708: payroll_action_id = p_user_payroll_action_id;
709:
710:

Line 754: ,pay_payroll_actions ppa

750: BEGIN
751: SELECT ptp.end_date
752: INTO p_expiry_information
753: FROM per_time_periods ptp
754: ,pay_payroll_actions ppa
755: WHERE ppa.payroll_action_id = p_owner_payroll_action_id
756: AND ppa.payroll_id = ptp.payroll_id
757: AND p_owner_effective_date BETWEEN ptp.start_date AND ptp.end_date;
758: END ASG_PTD_EC;