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_KW_PAYROLL_REGISTER dependencies on PAY_EMEA_PAYMNTS_ACTION_INFO_V

Line 538: ,pay_emea_paymnts_action_info_v pay_v

534: ,pay_v.narrative earn_element
535: ,pay_v.numeric_value earn_value
536: ,pai_ele.action_information7
537: FROM pay_action_information pai_ele
538: ,pay_emea_paymnts_action_info_v pay_v
539: ,pay_assignment_actions paa
540: WHERE paa.assignment_action_id = l_assact_id
541: AND paa.payroll_action_id = pai_ele.action_context_id
542: AND pai_ele.action_context_type = 'PA'

Line 584: ,pay_emea_paymnts_action_info_v pay_v

580: ,pay_v.narrative ded_element
581: ,pay_v.numeric_value ded_value
582: ,pai_ele.action_information7
583: FROM pay_action_information pai_ele
584: ,pay_emea_paymnts_action_info_v pay_v
585: ,pay_assignment_actions paa
586: WHERE paa.assignment_action_id= l_assact_id
587: AND paa.payroll_action_id = pai_ele.action_context_id
588: AND pai_ele.action_context_type = 'PA'

Line 653: ,pay_emea_paymnts_action_info_v pay_v

649: /* Cursor to get the sum of the Earnings for particular payroll for summary */
650: /*CURSOR csr_get_sum_earn_summary (l_org_name varchar2 , l_payroll_id number , l_effective_date date) IS
651: SELECT sum(pay_v.numeric_value)
652: FROM pay_action_information pai_ele
653: ,pay_emea_paymnts_action_info_v pay_v
654: ,pay_assignment_actions paa
655: WHERE paa.payroll_action_id = pai_ele.action_context_id
656: AND pai_ele.action_context_type = 'PA'
657: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'

Line 684: ,pay_emea_paymnts_action_info_v pay_v

680: CURSOR csr_get_sum_earn (l_org_structure_version_id number,
681: l_organization_id number , l_payroll_id number , l_effective_date date) IS
682: SELECT sum(pay_v.numeric_value)
683: FROM pay_action_information pai_ele
684: ,pay_emea_paymnts_action_info_v pay_v
685: ,pay_assignment_actions paa
686: WHERE paa.payroll_action_id = pai_ele.action_context_id
687: AND pai_ele.action_context_type = 'PA'
688: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'

Line 731: ,pay_emea_paymnts_action_info_v pay_v

727: ,pay_action_interlocks lck
728: ,pay_payroll_actions ppa1
729: ,pay_action_information pai_ele
730: ,pay_action_information pai_emp
731: ,pay_emea_paymnts_action_info_v pay_v
732: WHERE paa.payroll_action_id = pai_ele.action_context_id
733: AND pai_ele.action_context_type = 'PA'
734: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'
735: AND pai_ele.action_information7 IN ('E')

Line 780: ,pay_emea_paymnts_action_info_v pay_v

776: and ptp.end_date = l_effective_date;
777: CURSOR csr_seoo_split_2 (l_arch_assact number) IS
778: select SUM(pay_v.numeric_value)
779: from pay_action_information pai_ele
780: ,pay_emea_paymnts_action_info_v pay_v
781: ,pay_assignment_actions paa
782: where paa.payroll_action_id = pai_ele.action_context_id
783: and pai_ele.action_context_type = 'PA'
784: and pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'

Line 799: ,pay_emea_paymnts_action_info_v pay_v

795: CURSOR csr_get_sum_ded (l_org_structure_version_id number,
796: l_organization_id number , l_payroll_id number , l_effective_date date) IS
797: SELECT sum(pay_v.numeric_value)
798: FROM pay_action_information pai_ele
799: ,pay_emea_paymnts_action_info_v pay_v
800: ,pay_assignment_actions paa
801: WHERE paa.payroll_action_id = pai_ele.action_context_id
802: AND pai_ele.action_context_type = 'PA'
803: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'

Line 846: ,pay_emea_paymnts_action_info_v pay_v

842: ,pay_action_interlocks lck
843: ,pay_payroll_actions ppa1
844: ,pay_action_information pai_ele
845: ,pay_action_information pai_emp
846: ,pay_emea_paymnts_action_info_v pay_v
847: WHERE paa.payroll_action_id = pai_ele.action_context_id
848: AND pai_ele.action_context_type = 'PA'
849: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'
850: AND pai_ele.action_information7 IN ('D')

Line 895: ,pay_emea_paymnts_action_info_v pay_v

891: and ptp.end_date = l_effective_date;
892: CURSOR csr_sdoo_split_2 (l_arch_assact number) IS
893: select SUM(pay_v.numeric_value)
894: from pay_action_information pai_ele
895: ,pay_emea_paymnts_action_info_v pay_v
896: ,pay_assignment_actions paa
897: where paa.payroll_action_id = pai_ele.action_context_id
898: and pai_ele.action_context_type = 'PA'
899: and pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'