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 528: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

524: -- for TYE 2008 write the exceptions to the log file
525: PROCEDURE VALIDATE_TYE_DATA (
526: errbuf out nocopy varchar2,
527: retcode out nocopy number,
528: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
529: p_tax_yr_start_date IN DATE,
530: p_tax_yr_end_date IN DATE
531: )is
532: /* Cursor to select all Income Sars Codes which have negative balances*/

Line 728: pay_payroll_actions ppa,

724: p_end_date DATE) IS
725: select paa.assignment_action_id
726: from pay_action_contexts pac,
727: pay_assignment_actions paa,
728: pay_payroll_actions ppa,
729: ff_contexts ffc
730: where paa.assignment_id = p_asgn_id
731: and paa.payroll_action_id = ppa.payroll_action_id
732: and ppa.action_type in ('R', 'Q','B')

Line 744: pay_payroll_actions ppa,

740: /*Cursor the fetch all element names which have missing clearance numbers for given assignment_id*/
741: CURSOR elem_names_cur (p_asgn_ac_id pay_assignment_actions.assignment_action_id%type)IS
742: Select element_name
743: FROM pay_assignment_actions paa,
744: pay_payroll_actions ppa,
745: pay_element_types_f pet,
746: pay_input_values_f piv,
747: pay_run_results prr,
748: pay_run_result_values prv

Line 843: , pay_payroll_actions PACT

839: , pay_run_result_values TARGET
840: , pay_run_results RR
841: , per_time_periods PPTP
842: , per_time_periods BPTP
843: , pay_payroll_actions PACT
844: , pay_assignment_actions ASSACT
845: , pay_payroll_actions BACT
846: , pay_assignment_actions BAL_ASSACT
847: , pay_element_types_f ELEM

Line 845: , pay_payroll_actions BACT

841: , per_time_periods PPTP
842: , per_time_periods BPTP
843: , pay_payroll_actions PACT
844: , pay_assignment_actions ASSACT
845: , pay_payroll_actions BACT
846: , pay_assignment_actions BAL_ASSACT
847: , pay_element_types_f ELEM
848: where BAL_ASSACT.assignment_action_id = p_asgn_action_id
849: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id

Line 901: pay_payroll_actions ppa

897: add_months(per.date_of_birth,780) dateb--Added for TYE09
898: FROM pay_assignment_actions paa,
899: per_all_assignments_f asgn2,
900: per_all_people_f per,
901: pay_payroll_actions ppa
902: WHERE paa.assignment_action_id = asgn_ac_id
903: AND ppa.payroll_action_id = paa.payroll_action_id
904: AND asgn2.assignment_id = paa.assignment_id
905: AND per.person_id = asgn2.person_id

Line 3255: from pay_payroll_actions ppa,

3251: and ( :5 = ''1''
3252: OR (:6 =''2'' and aei.aei_information4 in (''01'',''02'',''03'',''11''))
3253: )
3254: and exists (select 1
3255: from pay_payroll_actions ppa,
3256: pay_assignment_actions paa,
3257: per_time_periods ptp
3258: where
3259: ppa.payroll_id=ass.payroll_id

Line 3921: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

3917:
3918: PROCEDURE VALIDATE_TYE_DATA_EOY2010 (
3919: errbuf out nocopy varchar2,
3920: retcode out nocopy number,
3921: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
3922: p_tax_yr_start_date IN DATE,
3923: p_tax_yr_end_date IN DATE,
3924: p_tax_year IN number,
3925: p_period_recon IN varchar2

Line 4150: , pay_payroll_actions PACT

4146: , pay_run_result_values TARGET
4147: , pay_run_results RR
4148: , per_time_periods PPTP
4149: , per_time_periods BPTP
4150: , pay_payroll_actions PACT
4151: , pay_assignment_actions ASSACT
4152: , pay_payroll_actions BACT
4153: , pay_assignment_actions BAL_ASSACT
4154: , pay_element_types_f ELEM

Line 4152: , pay_payroll_actions BACT

4148: , per_time_periods PPTP
4149: , per_time_periods BPTP
4150: , pay_payroll_actions PACT
4151: , pay_assignment_actions ASSACT
4152: , pay_payroll_actions BACT
4153: , pay_assignment_actions BAL_ASSACT
4154: , pay_element_types_f ELEM
4155: , pay_balance_types PBT
4156: where BAL_ASSACT.assignment_action_id = p_asgn_action_id

Line 4332: l_leg_param pay_payroll_actions.legislative_parameters%type;

4328: l_run_ass_act_id number;
4329: l_run_action_seq number;
4330: l_directive1 varchar2(100);
4331: l_ass_act_id pay_assignment_actions.assignment_action_id%type;
4332: l_leg_param pay_payroll_actions.legislative_parameters%type;
4333: l_rec_count varchar2(100);
4334: l_age varchar2(100);
4335: l_4116_val number;
4336:

Line 4419: from pay_payroll_actions

4415:
4416: --For ITREG no validations required as codes are not archived.
4417: select legislative_parameters
4418: into l_leg_param
4419: from pay_payroll_actions
4420: where payroll_action_id = p_payroll_action_id;
4421:
4422: --For ITREG certificate dont do any validations
4423: if pay_za_irp5_archive_pkg.get_parameter('CERT_TYPE', l_leg_param)=2 then

Line 4745: pay_payroll_actions ppa,

4741:
4742: select max(paa.action_sequence)
4743: into l_run_action_seq
4744: from pay_assignment_actions paa,
4745: pay_payroll_actions ppa,
4746: per_time_periods ptp
4747: where paa.assignment_id = rec_asgn.assignment_id
4748: and paa.action_status IN ('C','S') -- 10376999
4749: and paa.payroll_action_id = ppa.payroll_action_id