APPS.PAY_CN_SOE dependencies on PAY_PAYROLL_ACTIONS

Line 189: FROM pay_payroll_actions ppa

185:
186: CURSOR csr_get_date_earned
187: IS
188: SELECT ppa.date_earned
189: FROM pay_payroll_actions ppa
190: , pay_assignment_actions paa
191: WHERE ppa.payroll_action_id = paa.payroll_action_id
192: AND paa.assignment_action_id = p_assignment_action_id;
193:

Line 200: , pay_payroll_actions ppa

196: SELECT hsck.segment1
197: FROM hr_soft_coding_keyflex hsck
198: , per_assignments_f paf
199: , pay_assignment_actions paa
200: , pay_payroll_actions ppa
201: WHERE hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
202: AND paa.assignment_action_id = p_assignment_action_id
203: AND paa.payroll_action_id = ppa.payroll_action_id
204: AND paf.assignment_id = paa.assignment_id

Line 405: FROM pay_payroll_actions ppa

401:
402: CURSOR csr_get_date_earned
403: IS
404: SELECT ppa.date_earned, ppa.business_group_id
405: FROM pay_payroll_actions ppa
406: , pay_assignment_actions paa
407: WHERE ppa.payroll_action_id = paa.payroll_action_id
408: AND paa.assignment_action_id = p_assignment_action_id;
409:

Line 416: , pay_payroll_actions ppa

412: SELECT hsck.segment1
413: FROM hr_soft_coding_keyflex hsck
414: , per_assignments_f paf
415: , pay_assignment_actions paa
416: , pay_payroll_actions ppa
417: WHERE hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
418: AND paa.assignment_action_id = p_assignment_action_id
419: AND paa.payroll_action_id = ppa.payroll_action_id
420: AND paf.assignment_id = paa.assignment_id

Line 489: ,pay_payroll_actions ppa

485: ,pay_element_types_f pet
486: ,pay_element_links_f pel
487: ,pay_element_entries_f pee
488: ,pay_assignment_actions paa
489: ,pay_payroll_actions ppa
490: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
491: AND pel.element_type_id = pet.element_type_id
492: AND pee.element_link_id = pel.element_link_id
493: AND paa.assignment_id = pee.assignment_id

Line 508: FROM pay_payroll_actions ppa

504:
505: CURSOR csr_get_date_earned
506: IS
507: SELECT ppa.date_earned
508: FROM pay_payroll_actions ppa
509: , pay_assignment_actions paa
510: WHERE ppa.payroll_action_id = paa.payroll_action_id
511: AND paa.assignment_action_id = p_assignment_action_id;
512:

Line 627: ,pay_payroll_actions ppa

623: ,TO_CHAR(decode(pet.processing_type,''R'',least(pab.date_end,PTP.END_DATE),pab.date_end),''DD-Mon-YYYY'') COL03
624: ,TO_CHAR(decode(pet.processing_type,''R'',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours))
625: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
626: FROM pay_assignment_actions paa
627: ,pay_payroll_actions ppa
628: ,pay_run_results prr
629: ,pay_run_result_values prrv
630: ,per_time_periods ptp
631: ,pay_element_types_f pet

Line 698: FROM pay_payroll_actions ppa

694: l_assignment_action_id := p_assignment_action_id;
695: END IF;
696:
697: g_sql := 'SELECT ppa.pay_advice_message COL01
698: FROM pay_payroll_actions ppa
699: , pay_assignment_actions paa
700: WHERE ppa.payroll_action_id = paa.payroll_action_id
701: AND paa.assignment_action_id = ' || l_assignment_action_id;
702: