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_PAYROLLS_F_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 406: from pay_all_payrolls_f prl

402: ) is
403: --
404: cursor csr_payroll_exists is
405: SELECT prl.payroll_id
406: from pay_all_payrolls_f prl
407: where upper(prl.payroll_name) = upper(p_payroll_name)
408: and (prl.payroll_id <> p_payroll_id or
409: p_payroll_id is null)
410: and prl.business_group_id + 0 = p_business_group_id;

Line 1554: CURSOR C IS SELECT rowid FROM PAY_ALL_PAYROLLS_F

1550: X_Period_Reset_Years VARCHAR2 DEFAULT NULL,
1551: X_payslip_view_date_offset NUMBER DEFAULT NULL
1552: ) IS
1553: --
1554: CURSOR C IS SELECT rowid FROM PAY_ALL_PAYROLLS_F
1555: WHERE payroll_id = X_Payroll_Id;
1556: --
1557: CURSOR C2 IS SELECT pay_payrolls_s.nextval FROM sys.dual;
1558: --

Line 1884: CURSOR C IS SELECT rowid, comment_id FROM PAY_ALL_PAYROLLS_F

1880: ,X_Comment_Id OUT nocopy NUMBER --out type added
1881: --bug 5609830 / 5144323 TEST ends
1882: ) IS
1883: --
1884: CURSOR C IS SELECT rowid, comment_id FROM PAY_ALL_PAYROLLS_F
1885: WHERE payroll_id = X_Payroll_Id;
1886: --
1887: l_midpoint_offset number := 0 ;
1888: --

Line 1896: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE ;

1892: l_opm_object_version_number number;
1893: l_opm_effective_start_date date;
1894: l_opm_effective_end_date date;
1895:
1896: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE ;
1897: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE ;
1898: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE ;
1899:
1900: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;

Line 1897: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE ;

1893: l_opm_effective_start_date date;
1894: l_opm_effective_end_date date;
1895:
1896: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE ;
1897: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE ;
1898: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE ;
1899:
1900: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
1901: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;

Line 1898: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE ;

1894: l_opm_effective_end_date date;
1895:
1896: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE ;
1897: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE ;
1898: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE ;
1899:
1900: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
1901: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
1902: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE;

Line 2831: from pay_all_payrolls_f

2827: l_prl_object_version_number NUMBER;
2828:
2829: cursor csr_prl_ovn is
2830: select object_version_number
2831: from pay_all_payrolls_f
2832: where rowid = X_Rowid;
2833:
2834: cursor csr_prl_rowid is
2835: select rowid

Line 2836: from pay_all_payrolls_f

2832: where rowid = X_Rowid;
2833:
2834: cursor csr_prl_rowid is
2835: select rowid
2836: from pay_all_payrolls_f
2837: where payroll_id = l_Payroll_id
2838: and object_version_number = l_prl_object_version_number;
2839: --
2840: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE ;

Line 2840: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE ;

2836: from pay_all_payrolls_f
2837: where payroll_id = l_Payroll_id
2838: and object_version_number = l_prl_object_version_number;
2839: --
2840: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE ;
2841: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE ;
2842: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE ;
2843: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
2844: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;

Line 2841: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE ;

2837: where payroll_id = l_Payroll_id
2838: and object_version_number = l_prl_object_version_number;
2839: --
2840: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE ;
2841: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE ;
2842: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE ;
2843: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
2844: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
2845: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE;

Line 2842: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE ;

2838: and object_version_number = l_prl_object_version_number;
2839: --
2840: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE ;
2841: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE ;
2842: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE ;
2843: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
2844: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
2845: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE;
2846: --

Line 3058: from pay_all_payrolls_f

3054: l_prl_object_version_number NUMBER;
3055:
3056: cursor csr_prl_ovn is
3057: select object_version_number
3058: from pay_all_payrolls_f
3059: where rowid = X_Rowid;
3060: --
3061: BEGIN
3062: --