APPS.PAY_HK_SOE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 431: FROM pay_payroll_actions ppa

427:
428: CURSOR csr_get_date_earned
429: IS
430: SELECT ppa.date_earned, paa.tax_unit_id
431: FROM pay_payroll_actions ppa
432: , pay_assignment_actions paa
433: WHERE ppa.payroll_action_id = paa.payroll_action_id
434: AND paa.assignment_action_id = p_assignment_action_id;
435:

Line 586: l_effective_date pay_payroll_actions.effective_date%TYPE;

582: IS
583:
584: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
585: l_business_group_id per_business_groups.business_group_id%TYPE;
586: l_effective_date pay_payroll_actions.effective_date%TYPE;
587:
588: CURSOR csr_prepayment
589: IS
590: SELECT MAX(locked_action_id)

Line 597: FROM pay_payroll_actions ppa

593:
594: CURSOR csr_get_bg_id
595: IS
596: SELECT ppa.business_group_id,ppa.effective_date
597: FROM pay_payroll_actions ppa
598: ,pay_assignment_actions paa
599: WHERE ppa.payroll_action_id = paa.payroll_action_id
600: AND paa.assignment_action_id = p_assignment_action_id;
601:

Line 695: FROM pay_payroll_actions ppa

691:
692: CURSOR csr_get_date_earned
693: IS
694: SELECT ppa.date_earned, ppa.business_group_id, paa.tax_unit_id
695: FROM pay_payroll_actions ppa
696: , pay_assignment_actions paa
697: WHERE ppa.payroll_action_id = paa.payroll_action_id
698: AND paa.assignment_action_id = p_assignment_action_id;
699:

Line 783: ,pay_payroll_actions ppa

779: ,pay_element_types_f pet
780: ,pay_element_links_f pel
781: ,pay_element_entries_f pee
782: ,pay_assignment_actions paa
783: ,pay_payroll_actions ppa
784: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
785: AND pel.element_type_id = pet.element_type_id
786: AND pee.element_link_id = pel.element_link_id
787: AND paa.assignment_id = pee.assignment_id

Line 806: FROM pay_payroll_actions ppa

802:
803: CURSOR csr_get_date_earned(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
804: IS
805: SELECT ppa.date_earned
806: FROM pay_payroll_actions ppa
807: , pay_assignment_actions paa
808: WHERE ppa.payroll_action_id = paa.payroll_action_id
809: AND paa.assignment_action_id = c_assignment_action_id;
810:

Line 943: ,pay_payroll_actions ppa

939: ,TO_CHAR(decode(pet.processing_type,''R'',least(pab.date_end,PTP.END_DATE),pab.date_end),''DD-Mon-YYYY'') COL03
940: ,hr_general.decode_lookup(''HOURS_OR_DAYS'',pat.HOURS_OR_DAYS) COL04
941: ,TO_CHAR(decode(pet.processing_type,''R'',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours))) COL16
942: FROM pay_assignment_actions paa
943: ,pay_payroll_actions ppa
944: ,pay_run_results prr
945: ,pay_run_result_values prrv
946: ,per_time_periods ptp
947: ,pay_element_types_f pet