eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ZA_EOY_VAL dependencies on PAY_PAYROLL_ACTIONS

Line 372: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

368: -- for TYE 2008 write the exceptions to the log file
369: PROCEDURE VALIDATE_TYE_DATA (
370: errbuf out nocopy varchar2,
371: retcode out nocopy number,
372: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
373: p_tax_yr_start_date IN DATE,
374: p_tax_yr_end_date IN DATE
375: )is
376: /* Cursor to select all Income Sars Codes which have negative balances*/

Line 547: pay_payroll_actions ppa,

543: p_end_date DATE) IS
544: select paa.assignment_action_id
545: from pay_action_contexts pac,
546: pay_assignment_actions paa,
547: pay_payroll_actions ppa,
548: ff_contexts ffc
549: where paa.assignment_id = p_asgn_id
550: and paa.payroll_action_id = ppa.payroll_action_id
551: and ppa.action_type in ('R', 'Q','B')

Line 563: pay_payroll_actions ppa,

559: /*Cursor the fetch all element names which have missing clearance numbers for given assignment_id*/
560: CURSOR elem_names_cur (p_asgn_ac_id pay_assignment_actions.assignment_action_id%type)IS
561: Select element_name
562: FROM pay_assignment_actions paa,
563: pay_payroll_actions ppa,
564: pay_element_types_f pet,
565: pay_input_values_f piv,
566: pay_run_results prr,
567: pay_run_result_values prv

Line 663: , pay_payroll_actions PACT

659: , pay_run_result_values TARGET
660: , pay_run_results RR
661: , per_time_periods PPTP
662: , per_time_periods BPTP
663: , pay_payroll_actions PACT
664: , pay_assignment_actions ASSACT
665: , pay_payroll_actions BACT
666: , pay_assignment_actions BAL_ASSACT
667: , pay_element_types_f ELEM

Line 665: , pay_payroll_actions BACT

661: , per_time_periods PPTP
662: , per_time_periods BPTP
663: , pay_payroll_actions PACT
664: , pay_assignment_actions ASSACT
665: , pay_payroll_actions BACT
666: , pay_assignment_actions BAL_ASSACT
667: , pay_element_types_f ELEM
668: where BAL_ASSACT.assignment_action_id = p_asgn_action_id
669: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id

Line 713: pay_payroll_actions ppa

709: SELECT per.employee_number empno, asgn2.assignment_number assgno
710: FROM pay_assignment_actions paa,
711: per_all_assignments_f asgn2,
712: per_all_people_f per,
713: pay_payroll_actions ppa
714: WHERE paa.assignment_action_id = asgn_ac_id
715: AND ppa.payroll_action_id = paa.payroll_action_id
716: AND asgn2.assignment_id = paa.assignment_id
717: AND per.person_id = asgn2.person_id