APPS.PAY_IE_PAYE_PKG dependencies on FND_SESSIONS

Line 344: -- ,FND_SESSIONS SESH

340: PAY_ELEMENT_ENTRY_VALUES_F VALUE,
341: PAY_ELEMENT_ENTRIES_F ENTRY,
342: PER_TIME_PERIODS PTP,
343: PAY_PAYROLL_ACTIONS PACT
344: -- ,FND_SESSIONS SESH
345: WHERE
346: PACT.PAYROLL_ACTION_ID = P_PAYROLL_ACTION_ID AND
347: --PTP.TIME_PERIOD_ID = PACT.TIME_PERIOD_ID AND -- Bug 5070091 Offset payroll change
348: PACT.PAYROLL_ID = PTP.PAYROLL_ID AND

Line 770: FROM ff_globals_f,fnd_sessions ses

766: RETURN number
767: is
768: CURSOR get_global_val(l_name IN VARCHAR2) IS
769: SELECT global_value
770: FROM ff_globals_f,fnd_sessions ses
771: WHERE global_name = l_name
772: AND ses.session_id = userenv('SESSIONID')
773: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
774: --

Line 777: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses

773: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
774: --
775: CURSOR get_pay_frequency_csr IS
776: SELECT pp.period_type
777: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses
778: WHERE pa.assignment_id = p_assignment_id
779: AND ses.session_id = userenv('SESSIONID')
780: AND ses.effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date
781: AND pp.payroll_id = pa.payroll_id

Line 786: FROM pay_ie_paye_details_f pp,fnd_sessions ses

782: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
783: --
784: CURSOR monthly_std_rate_cut_off IS
785: SELECT nvl(pp.monthly_std_rate_cut_off,0)
786: FROM pay_ie_paye_details_f pp,fnd_sessions ses
787: WHERE pp.assignment_id=p_assignment_id
788: AND ses.session_id = userenv('SESSIONID')
789: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
790: --

Line 832: FROM ff_globals_f,fnd_sessions ses

828: RETURN number
829: is
830: CURSOR get_global_val(l_name IN VARCHAR2) IS
831: SELECT global_value
832: FROM ff_globals_f,fnd_sessions ses
833: WHERE global_name = l_name
834: AND ses.session_id = userenv('SESSIONID')
835: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
836: --

Line 839: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses

835: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
836: --
837: CURSOR get_pay_frequency_csr IS
838: SELECT pp.period_type
839: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses
840: WHERE pa.assignment_id = p_assignment_id
841: AND ses.session_id = userenv('SESSIONID')
842: AND ses.effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date
843: AND pp.payroll_id = pa.payroll_id

Line 848: FROM pay_ie_paye_details_f pp,fnd_sessions ses

844: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
845: --
846: CURSOR monthly_tax_credit IS
847: SELECT nvl(pp.monthly_tax_credit,0)
848: FROM pay_ie_paye_details_f pp,fnd_sessions ses
849: WHERE pp.assignment_id=p_assignment_id
850: AND ses.session_id = userenv('SESSIONID')
851: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
852: --

Line 899: FROM ff_globals_f,fnd_sessions ses

895: RETURN number
896: is
897: CURSOR get_global_val(l_name IN VARCHAR2) IS
898: SELECT global_value
899: FROM ff_globals_f,fnd_sessions ses
900: WHERE global_name = l_name
901: AND ses.session_id = userenv('SESSIONID')
902: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
903: --

Line 906: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses

902: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
903: --
904: CURSOR get_pay_frequency_csr IS
905: SELECT pp.period_type
906: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses
907: WHERE pa.assignment_id = p_assignment_id
908: AND ses.session_id = userenv('SESSIONID')
909: AND ses.effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date
910: AND pp.payroll_id = pa.payroll_id

Line 915: FROM pay_ie_paye_details_f pp,fnd_sessions ses

911: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
912: --
913: CURSOR weekly_std_rate_cut_off IS
914: SELECT nvl(pp.weekly_std_rate_cut_off,0)
915: FROM pay_ie_paye_details_f pp,fnd_sessions ses
916: WHERE pp.assignment_id=p_assignment_id
917: AND ses.session_id = userenv('SESSIONID')
918: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
919: --

Line 962: FROM ff_globals_f,fnd_sessions ses

958: RETURN number
959: is
960: CURSOR get_global_val(l_name IN VARCHAR2) IS
961: SELECT global_value
962: FROM ff_globals_f,fnd_sessions ses
963: WHERE global_name = l_name
964: AND ses.session_id = userenv('SESSIONID')
965: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
966: --

Line 969: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses

965: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
966: --
967: CURSOR get_pay_frequency_csr IS
968: SELECT pp.period_type
969: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses
970: WHERE pa.assignment_id = p_assignment_id
971: AND ses.session_id = userenv('SESSIONID')
972: AND ses.effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date
973: AND pp.payroll_id = pa.payroll_id

Line 978: FROM pay_ie_paye_details_f pp,fnd_sessions ses

974: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
975: --
976: CURSOR weekly_tax_credit IS
977: SELECT nvl(pp.weekly_tax_credit,0)
978: FROM pay_ie_paye_details_f pp,fnd_sessions ses
979: WHERE pp.assignment_id=p_assignment_id
980: AND ses.session_id = userenv('SESSIONID')
981: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
982: --