APPS.PAY_CN_SOE dependencies on PAY_PAYROLL_ACTIONS

Line 216: FROM pay_payroll_actions ppa

212:
213: CURSOR csr_get_date_earned
214: IS
215: SELECT ppa.date_earned
216: FROM pay_payroll_actions ppa
217: , pay_assignment_actions paa
218: WHERE ppa.payroll_action_id = paa.payroll_action_id
219: AND paa.assignment_action_id = p_assignment_action_id;
220:

Line 227: , pay_payroll_actions ppa

223: SELECT hsck.segment1
224: FROM hr_soft_coding_keyflex hsck
225: , per_assignments_f paf
226: , pay_assignment_actions paa
227: , pay_payroll_actions ppa
228: WHERE hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
229: AND paa.assignment_action_id = p_assignment_action_id
230: AND paa.payroll_action_id = ppa.payroll_action_id
231: AND paf.assignment_id = paa.assignment_id

Line 434: FROM pay_payroll_actions ppa

430:
431: CURSOR csr_get_date_earned
432: IS
433: SELECT ppa.date_earned, ppa.business_group_id
434: FROM pay_payroll_actions ppa
435: , pay_assignment_actions paa
436: WHERE ppa.payroll_action_id = paa.payroll_action_id
437: AND paa.assignment_action_id = p_assignment_action_id;
438:

Line 445: , pay_payroll_actions ppa

441: SELECT hsck.segment1
442: FROM hr_soft_coding_keyflex hsck
443: , per_assignments_f paf
444: , pay_assignment_actions paa
445: , pay_payroll_actions ppa
446: WHERE hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
447: AND paa.assignment_action_id = p_assignment_action_id
448: AND paa.payroll_action_id = ppa.payroll_action_id
449: AND paf.assignment_id = paa.assignment_id

Line 518: ,pay_payroll_actions ppa

514: ,pay_element_types_f pet
515: ,pay_element_links_f pel
516: ,pay_element_entries_f pee
517: ,pay_assignment_actions paa
518: ,pay_payroll_actions ppa
519: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
520: AND pel.element_type_id = pet.element_type_id
521: AND pee.element_link_id = pel.element_link_id
522: AND paa.assignment_id = pee.assignment_id

Line 549: ,pay_payroll_actions ppa

545: ,pay_element_types_f pet
546: ,pay_element_links_f pel
547: ,pay_element_entries_f pee
548: ,pay_assignment_actions paa
549: ,pay_payroll_actions ppa
550: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
551: AND pel.element_type_id = pet.element_type_id
552: AND pee.element_link_id = pel.element_link_id
553: AND paa.assignment_id = pee.assignment_id

Line 570: FROM pay_payroll_actions ppa

566:
567: CURSOR csr_get_date_earned
568: IS
569: SELECT ppa.date_earned
570: FROM pay_payroll_actions ppa
571: , pay_assignment_actions paa
572: WHERE ppa.payroll_action_id = paa.payroll_action_id
573: AND paa.assignment_action_id = p_assignment_action_id;
574:

Line 710: ,pay_payroll_actions ppa

706: ,TO_CHAR(decode(pet.processing_type,''R'',least(pab.date_end,PTP.END_DATE),pab.date_end),''DD-Mon-YYYY'') COL03
707: ,TO_CHAR(decode(pet.processing_type,''R'',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours))
708: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
709: FROM pay_assignment_actions paa
710: ,pay_payroll_actions ppa
711: ,pay_run_results prr
712: ,pay_run_result_values prrv
713: ,per_time_periods ptp
714: ,pay_element_types_f pet

Line 782: FROM pay_payroll_actions ppa

778: l_assignment_action_id := p_assignment_action_id;
779: END IF;
780:
781: g_sql := 'SELECT ppa.pay_advice_message COL01
782: FROM pay_payroll_actions ppa
783: , pay_assignment_actions paa
784: WHERE ppa.payroll_action_id = paa.payroll_action_id
785: AND paa.assignment_action_id = ' || l_assignment_action_id;
786: