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_IN_PF_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 110: FROM pay_payroll_actions

106: INSTR(legislative_parameters||' ',' ',
107: INSTR(legislative_parameters||' ',p_token||'='))
108: - (INSTR(legislative_parameters||' ',p_token||'=')+LENGTH(p_token||'='))),
109: business_group_id
110: FROM pay_payroll_actions
111: WHERE payroll_action_id = p_pact_id;
112:
113: l_business_group_id VARCHAR2(20);
114: l_token_value VARCHAR2(50);

Line 181: ,pay_payroll_actions ppa

177: CURSOR csr_arch_ref_no
178: IS
179: SELECT 1
180: FROM pay_action_information pai
181: ,pay_payroll_actions ppa
182: WHERE pai.action_information_category = 'IN_PF_BUSINESS_NUMBER'
183: AND pai.action_context_type = 'PA'
184: AND pai.action_information2 = g_arc_ref_no
185: AND pai.action_context_id = ppa.payroll_action_id

Line 828: FROM pay_payroll_actions

824: FETCH csr_reg_company INTO l_reg_comp_name ;
825: CLOSE csr_reg_company ;
826:
827: SELECT business_group_id INTO l_bus_group_id --Business Group Id
828: FROM pay_payroll_actions
829: WHERE payroll_action_id =p_arc_pay_action_id;
830:
831: pay_in_utils.set_location(g_debug,'Business Number : '||p_business_number,15);
832:

Line 1350: pay_payroll_actions ppa_init,

1346: CURSOR csr_process_assignments
1347: IS
1348: SELECT DISTINCT paa_init.assignment_id
1349: FROM pay_assignment_actions paa_init,
1350: pay_payroll_actions ppa_init,
1351: per_assignments_f paf,
1352: hr_organization_information hoi
1353: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id
1354: AND ppa_init.action_type IN ('P','U','I')

Line 1386: pay_payroll_actions ppa_init,

1382: CURSOR csr_process_supp_assignments(p_business_no VARCHAR2 )
1383: IS
1384: SELECT DISTINCT paa_init.assignment_id
1385: FROM pay_assignment_actions paa_init,
1386: pay_payroll_actions ppa_init,
1387: per_assignments_f paf,
1388: hr_organization_information hoi
1389: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id
1390: AND ppa_init.action_type IN ('P','U','I')

Line 1414: ,pay_payroll_actions ppa

1410: AND NOT EXISTS ( SELECT paa.assignment_id
1411: FROM pay_assignment_actions paa
1412: ,pay_action_information pai
1413: ,hr_organization_information hoi
1414: ,pay_payroll_actions ppa
1415: WHERE paa.assignment_id = paa_init.assignment_id
1416: AND paa.assignment_action_id = pai.action_context_id
1417: AND ppa.payroll_action_id = paa.payroll_action_id
1418: AND ppa.report_type = 'IN_PF_ARCHIVE'

Line 1433: pay_payroll_actions ppa_init,

1429: UNION
1430: SELECT DISTINCT paa_init.assignment_id
1431: FROM pay_assignment_actions paa_init,
1432: per_periods_of_service pps,
1433: pay_payroll_actions ppa_init,
1434: per_assignments_f paf,
1435: hr_organization_information hoi
1436: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id
1437: AND paf.period_of_service_id = pps.period_of_service_id

Line 1464: ,pay_payroll_actions ppa

1460: FROM pay_assignment_actions paa
1461: ,pay_action_information pai
1462: ,hr_organization_information hoi
1463: ,hr_organization_units hou
1464: ,pay_payroll_actions ppa
1465: WHERE paa.assignment_id = paa_init.assignment_id
1466: AND paa.assignment_action_id = pai.action_context_id
1467: AND ppa.payroll_action_id = paa.payroll_action_id
1468: AND hoi.organization_id = hou.organization_id

Line 1492: pay_payroll_actions ppa_init,

1488: CURSOR csr_process_rev_assignments(p_business_no VARCHAR2)
1489: IS
1490: SELECT DISTINCT paa_init.assignment_id
1491: FROM pay_assignment_actions paa_init,
1492: pay_payroll_actions ppa_init,
1493: per_assignments_f paf,
1494: hr_organization_information hoi
1495: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id
1496: AND ppa_init.action_type IN ('P','U','I')

Line 1535: pay_payroll_Actions ppa

1531: AND hoi_challan.org_information1 = g_challan_year
1532: AND hoi_challan.org_information2 = g_challan_mth
1533: AND NOT EXISTS (SELECT pai.action_information8
1534: FROM pay_action_information pai,
1535: pay_payroll_Actions ppa
1536: WHERE pai.action_information8 = hoi_challan.org_information12
1537: AND pai.action_information_category = 'IN_PF_CHALLAN'
1538: AND pai.action_context_type = 'PA'
1539: AND pai.action_information3 = p_pf_org

Line 1604: pay_payroll_Actions ppa

1600: IS
1601: SELECT DISTINCT action_context_id
1602: FROM pay_action_information pai,
1603: pay_assignment_actions paa,
1604: pay_payroll_Actions ppa
1605: WHERE action_information2 = p_arc_ref
1606: AND action_context_type = 'AAP'
1607: AND action_information_category = 'IN_PF_PERSON_DTLS'
1608: AND action_information1 = nvl(p_business_no,action_information1)

Line 1914: ,pay_payroll_actions ppa

1910: ,p_assignment_id NUMBER)
1911: IS
1912: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) run_asg_action_id
1913: FROM pay_assignment_actions paa
1914: ,pay_payroll_actions ppa
1915: ,per_assignments_f paf
1916: WHERE paf.assignment_id = paa.assignment_id
1917: AND paf.assignment_id = p_assignment_id
1918: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1928: pay_payroll_actions ppa1

1924: AND (1 = DECODE(ppa.action_type,'I',1,0)
1925: OR EXISTS (SELECT ''
1926: FROM pay_action_interlocks intk,
1927: pay_assignment_actions paa1,
1928: pay_payroll_actions ppa1
1929: WHERE intk.locked_action_id = paa.assignment_Action_id
1930: AND intk.locking_action_id = paa1.assignment_action_id
1931: AND paa1.payroll_action_id =ppa1.payroll_action_id
1932: AND paa1.assignment_id = p_assignment_id